Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have an application that runs on a web browser (a web application but just for internal company users).
In that application should have a button "generate report".
When the user clicks that button, it should run a Power BI .pbix file, generate the charts that already exist in that file, publish it and then return the url with the updated chart for the user to see in the application (in an iframe that renders the power bi report url). The data that will be used to generate the charts should come from the application. This data can be different for each user and each time the report is generated. So the report is dynamic and will be different most of the times the "generate report" button is clicked.
Power BI is never opened by the user. The user interacts just with the application.
How to do that?
I know Power BI can read .json, .csv and rest api. My application could provide any of those options. But it should not require the user to open Power BI to do that.
When the user clicks that button, it should run a Power BI .pbix file, generate the charts that already exist in that file, publish it and then return the url with the updated chart for the user to see in the application (in an iframe that renders the power bi report url).
That's not how Power BI works. Instead, consider running DAX queries against the Power BI semantic model from your app and render your graphs yourself, or use the proper Power BI Embedded setup.
Keep in mind that none of this is instantaneous. Your UX will not be great.
What do you mean of not being instantaneous? The chart will not be updated when clicking the application button?
Also, appreciate if you can point some links with examples on the alternatives you suggested.
The chart will not be updated when clicking the application button?
No, it will not.
Why you should care about the Power BI ExecuteQueries API (endjin.com)
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |