Report on Sharepoint Lists in Sharepoint Template

Question

Hi,&nbsp;I want to create a Sharepoint Template with integrated Power BI Reports, based on Lists in the actual Site.I've managed to create the template, but when I create a new site, based on this template, I need to do&nbsp;the following.&nbsp;Open the .pbix report in Power BI Desktop.Change the datasource.Publish the report to the new new site.Change the embed-link in the web-parts.&nbsp;I hope there&nbsp;is a easier solution.&nbsp;Any suggestions are appreciated.&nbsp;Thannks in advance&nbsp;Svenson

anonymous · Answer

nesv,

From Power BI side, to simplify the process, you can create data source parameter in your PBIX file following the guide in the blog below. This way, you can choose different source each time and when you publish the PBIX file to Power BI Service, the embed link is always the same.

http://biinsight.com/power-bi-desktop-query-parameters-part-1/

Regards,
Lydia

nesv · Answer

Anonymous,&nbsp;The parameters doesn't solve the data source problem.I can change the source, but I still have to change the ID for the List-table, in Advanced Editor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

nesv,How about you create parameter for ID in Advanced Editor?Regards,Lydia

nesv · Answer

Anonymous&nbsp;I've googled for a while, and can't find any guide in getting the ID of a Sharepoint List.&nbsp;My mission is to create a Parameter (or a Query), that gets the ID of my List.Then I would be able to use this parameter later on :)&nbsp;Do you have any guide (or hint) that could lead me in the right direction?&nbsp;regards Svenson

anonymous · Answer

nesv,On Power BI side, you can add a new blank query and paste the following code to the Advanced Editor of the blank query.
let 
    parameterSource = (IDparameter as text) =&gt;

let
    Source = SharePoint.Tables("https://sharepointsite", [ApiVersion = 15]),
    #"getlist" = Source{[Id=""&amp;IDparameter&amp;""]}[Items],
    #"Renamed Columns" = Table.RenameColumns(#"getlist",{{"ID", "ID.1"}})
in
    #"Renamed Columns"

in
   parameterSource
Then manually enter ID in the function to get a table of that ID.&nbsp;/It is not possible to change ID when entering sharepoint site URL at the beginning.Regards,Lydia
&nbsp;

Forum Discussion

Report on Sharepoint Lists in Sharepoint Template

6 Replies

Related content

Sharepoint list mirroring

Extract Data from sharepoint

SharePoint Access

Incremental Refresh on Dataflow sourced from SharePoint

Sharepoint Shortcut