CODEWITHSUNDEEP
sharepointpowerbipowerbi-desktoppowerbi-embeddedpower-bi-report-server
Wasim
Wasim

Reputation: 724

Sending values from SharePoint list to Power BI Desktop

How can I sent values from a Share Point list to Power BI Desktop as a Parameters or whatever ,I've tried few ways like embedding values in links but it is not working , can someone explain it to me how can i do this ?

Upvotes: 0

Views: 592

Answers (2)

Treb Gatte
Treb Gatte

Reputation: 9

Parameters in Power BI work more like global variables rather than what you are used to in other tools. They are an excellent way to externalize references.

If you set a filter in Power Query for a specific subset of records, this filter will be folded (run at the datasource) rather than after the fact. Order is important when executing PQ commands for folding to occur.

I show this filtering in the video associated to my blog post here: https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/ I’m doing a series of posts that are SharePoint/PBI specific since the interaction between them is poorly documented.

Also, is your need user based? If so, take a look at RLS. This enables you to do dynamic filtering automatically, based on the viewing user’s profile.

Hope this helps! Treb Gatte Microsoft Power BI MVP

Upvotes: 0

AnkUser
AnkUser

Reputation: 5531

No you cannot do that. You can add some criteria to fetch data from sharepoint but that criteria will be static, for ex Id=1 shall be the criteria but you cannot directly add this criteria to sharepont and that too dynamic. You first need to load data into powerbi dataset so you will have records with all IDS and then you can add filters/slicers in powerbi

Upvotes: 2

Related Questions