Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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 ?
@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...
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,
Lydia
Yes, 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.