Forum Discussion

samaresh's avatar
samaresh
Frequent Visitor
9 years ago

Make dynamic oData souce

I want to develop a power BI app. To do this using power BI desktop i have prepare a pbix file where have 3 queries that return from sharepoient list using end point "/_vti_bin/ListData.svc". Usig th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

samaresh,

You can create a Power BI report template(PBIT) with data source parameter, then send the PBIT file to your users. The users can instantiate the PBIT and generate report with their own data, after that, they can publish the PBIX file to Power BI Service. For more details, please review the following  blog and similar thread.

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://community.powerbi.com/t5/Desktop/How-to-create-a-template-with-a-different-data-source-every-time/td-p/50969

Regards,

samaresh's avatar
samaresh
Frequent Visitor
9 years ago

Thanks for your reply. Actually i will have to publish the App in app source/App store. User will get the app from store and will start using it no way to make pbix file themself. There are lot of example in store like git gub, goodle analytics, QuickBooks etc. When user get that app in Power BI, It shows the current user specific reprots.

My expectation is when user access the app from store for first time it will ask the Sharepoint URL than it will load the data from that sharepoint and show the reports.