Forum Discussion
Multiple datasources and connections on API
Hi everyone!
My company is developing an web application, we want to work with Power BI via API or Embedded, the thing is, we have multiple costumers with different data on same structured datasources, on SQL. I'm using on-premise data gateway to connect my datasources online, but can i set different datasources to the same reports, dashboards according to the costumer's login on my application? Power BI its the best solution so far we encountered but we really need this to attend our needs.
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
5 Replies
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,
LydiaOk, 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,
Lydia
Is it now possible to do it in April 2021 ?
Another question : Wich products have you found that makes it possible ?
