Forum Discussion
Helper IPower BI Report - template (relative url datasource)
Hello folks,
Is it possible to create a Power BI Report with dynamic datasource based on SharePoint Lists. Example once add on Team Site's page, have lists datasource with it's relative Url. This way we don't need to edit every Power BI Report and it's url datasource.
Any tips are appriciated!
4 Replies
- amitchandak
Super User
gselvag , refer relative solution from past if they can help
https://community.powerbi.com/t5/Desktop/Dynamic-Data-Source-based-on-parameter/td-p/260077
Hi gselvag,
Did these data sources have the same data structures? Power query will cache the previous data structure into steps and not auto sync when the data source updates.
If their data structure dynamic changes, power query will return an error of 'key not matches'.
Regards,Xiaoxin Sheng
gselvagHi Anonymous
I'm building a Power BI Report that shall be default on Project Site's. The data structure is the same. How can we configure the PBI Report with dynamic lists, eg. {full_url} \lists\data1 as let PBI automate datasource based on which site it's added as WebPart on.
Best regards,
Geir
Hi gselvag,
You can try to parameterize your connection string with the query parameter, then you can modify the query parameter to achieve a dynamic data source.
Deep Dive into Query Parameters and Power BI Templates
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Regards,Xiaoxin Sheng
