Forum Discussion
Generating reports/visualizations for power BI embedded from within a web app?
Hello,
I was wondering is it possible for Power BI Embedded to be used for some kind of "real-time" report creation which can be then embedded in a web app. For example as part of web app, a user in an organisation can create an SQL query for some dataset from some predefined parameters/attributes from a series of dropdown menus on the UI, which ensure the query is properly structured and wont cause an error ( e.g. SELECT Player FROM PlayerRecords WHERE WinPercentage > 60% (These keywords would all be selectable from dropdown menus)) . Is there a way for that query to go to power BI which will then create a visualisation / report which can then be returned and embedded. I appreciate any responses with this, thank you.
Hi georgehos ,
According to my understanding, because the Power BI dataset itself uses AS model architecture, the query statement used is DAX, and SQL has nothing to do with your embedded front-end Power BI report to do the user interaction and filtering operations are done in the backend of the Power BI by the generation of DAX query statement to do the query and the front-end display of the data, so I think the use of Power BI comes with embed analytics can meet your needs, in the Power BI report to place filters and slicers, to these options for customers to choose, it is already enough.
Power BI embedded analytics overview - Power BI | Microsoft Learn
Slicers in Power BI - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi georgehos ,
According to my understanding, because the Power BI dataset itself uses AS model architecture, the query statement used is DAX, and SQL has nothing to do with your embedded front-end Power BI report to do the user interaction and filtering operations are done in the backend of the Power BI by the generation of DAX query statement to do the query and the front-end display of the data, so I think the use of Power BI comes with embed analytics can meet your needs, in the Power BI report to place filters and slicers, to these options for customers to choose, it is already enough.
Power BI embedded analytics overview - Power BI | Microsoft Learn
Slicers in Power BI - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.