Forum Discussion
Multiple datasources and connections on API
PaolaFarias,
Do you want to achieve that when user signs in application, he can change data source of the report embedded in the application? If so, according to my knowledge, it is not possible.
Regards,
Lydia
PaolaFarias,
Do you store different data for different customers in different SQL Server instances and different databases?
If so, in Power BI Desktop, you can consider to create a Power BI report template(PBIT) with data source parameters, then send the PBIT file to your customers . The customers 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,
Lydia
Ok, thank you very much, but unfortunately it doesn't attend to our needs now.
PaolaFarias,
Do you want to achieve that when user signs in application, he can change data source of the report embedded in the application? If so, according to my knowledge, it is not possible.
Regards,
LydiaYes, exactly what we are trying to do. See, we are a SaaS, and our costumers don't have time or knowledgement to change the datasources to see their reports... Anyway, we have found some products on the market that makes it possible. I have posted this suggestion on Ideas page already, hope power bi can support us on the future.
