building reports for SharePoint lists inside Power BI, are my reports achievable

%3CLINGO-SUB%20id%3D%22lingo-sub-2877157%22%20slang%3D%22en-US%22%3Ebuilding%20reports%20for%20SharePoint%20lists%20inside%20Power%20BI%2C%20are%20my%20reports%20achievable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2877157%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20build%203%20charts%20and%20show%20them%20inside%20my%20SharePoint%20online%20modern%20page%2C%20the%20charts%20are%20as%20follow%3A-%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22charts2types.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319464iE295938BDEA6B3AA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22charts2types.png%22%20alt%3D%22charts2types.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20First%20chart%20is%20to%20group%20the%20items%20from%20a%20single%20SharePoint%20list%20by%20Created%20date%2C%20and%20show%20the%20total%20number%20of%20items%20based%20on%20the%20day%20of%20the%20week%20(Mon%20till%20Sun).%20So%20for%20example%2C%20if%20today%20is%20Wednesday%2C%20it%20should%20show%20the%20results%20from%20past%20Tuesday%20till%20today%20(Wednesday)%3C%2FP%3E%3CP%3E2)%20Second%20chart%20is%20to%20show%20the%20total%20number%20of%20items%20from%204%20different%20lists%20and%20show%20the%20percentage%20inside%20a%20pie%20chart%3C%2FP%3E%3CP%3E3)%20Third%20chart%20is%20to%20group%20the%20items%20from%20a%20single%20SharePoint%20list%20by%20Created%20date%2C%20and%20show%20the%20total%20number%20of%20items%20based%20on%20the%20month%20from%20the%20first%20month%20of%20the%20year%20till%20current%20month.%3C%2FP%3E%3CP%3ESo%20can%20i%20build%20these%20charts%20using%20Power%20Bi%20and%20embed%20them%20inside%20SharePoint%20modern%20page%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2877157%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDevelopment%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2877193%22%20slang%3D%22en-US%22%3ERe%3A%20building%20reports%20for%20SharePoint%20lists%20inside%20Power%20BI%2C%20are%20my%20reports%20achievable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2877193%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F233354%22%20target%3D%22_blank%22%3E%40john%20john%3C%2FA%3E%26nbsp%3Bbe%20aware%20that%20any%20user%20who%20needs%20to%20view%20your%20charts%20will%20need%20a%20Power%20BI%20Pro%20licence.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2877803%22%20slang%3D%22en-US%22%3ERe%3A%20building%20reports%20for%20SharePoint%20lists%20inside%20Power%20BI%2C%20are%20my%20reports%20achievable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2877803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3Ethanks%20for%20the%20reply..%26nbsp%3B%20yes%20we%20already%20have%20this%20license%20for%20all%20users...%20but%20are%20those%20type%20of%20reports%2Fcharts%20achievable%20in%20PowerBI%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2878271%22%20slang%3D%22en-US%22%3ERe%3A%20building%20reports%20for%20SharePoint%20lists%20inside%20Power%20BI%2C%20are%20my%20reports%20achievable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2878271%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F233354%22%20target%3D%22_blank%22%3E%40john%20john%3C%2FA%3E%26nbsp%3B%20Yes%2C%20you%20can%20easily%20build%20such%20charts%20using%20Power%20BI%20and%20then%26nbsp%3Bembed%20Power%20BI%20report%20on%20modern%20page%20using%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-the-power-bi-web-part-32d8b85f-094d-4152-8e3b-df641ccf3968%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPower%20BI%20web%20part%3C%2FA%3E.%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3C%2FSTRONG%3E%3A%26nbsp%3BYou%20will%20need%20Power%20BI%20licenses%20(Pro%2FPremium)%20to%20share%20the%20reports%20with%20other%20users.%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2881475%22%20slang%3D%22en-US%22%3ERe%3A%20building%20reports%20for%20SharePoint%20lists%20inside%20Power%20BI%2C%20are%20my%20reports%20achievable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2881475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3Ewill%20the%20users%20who%20will%20be%20viewing%20the%20reports%20need%20license%20as%20well%3F%20or%20the%20license%20is%20only%20needed%20for%20the%20user%26nbsp%3B%20who%20will%20be%20developing%20the%20reports%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Valued Contributor

I want to build 3 charts and show them inside my SharePoint online modern page, the charts are as follow:-

 

charts2types.png

 

1) First chart is to group the items from a single SharePoint list by Created date, and show the total number of items based on the day of the week (Mon till Sun). So for example, if today is Wednesday, it should show the results from past Tuesday till today (Wednesday)

2) Second chart is to show the total number of items from 4 different lists and show the percentage inside a pie chart

3) Third chart is to group the items from a single SharePoint list by Created date, and show the total number of items based on the month from the first month of the year till current month.

So can i build these charts using Power Bi and embed them inside SharePoint modern page?

Thanks

5 Replies

@john john be aware that any user who needs to view your charts will need a Power BI Pro licence.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

@RobElliottthanks for the reply..  yes we already have this license for all users... but are those type of reports/charts achievable in PowerBI?

@john john  Yes, you can easily build such charts using Power BI and then embed Power BI report on modern page using Power BI web part.

Note: You will need Power BI licenses (Pro/Premium) to share the reports with other users.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@RobElliottwill the users who will be viewing the reports need license as well? or the license is only needed for the user  who will be developing the reports?

@john john,

 

Other users also need Power BI Pro or Premium Per User (PPU) licenses. 

Check this documentation: Share Power BI reports and dashboards with coworkers and others 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE