The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have an app built on Microsoft SQL server. We are looking to use Power BI embedded for clients to view their specific information from our database via predefined reports that we have created.
A requirement of these reports is that we need to use the SUMMARIZE and GENERATE DAX functions in a DAX created table. This is not available in a direct query report that is built in Power BI desktop.
So my question is, when we switch to Power BI embedded, will we be limited by the direct query limitations - as in we cannot create DAX tables? I am trying to build our current reports in line with what will be suitable for Power BI embedded as I would like to directly transfer them. Also, it is obviously important that our reports are always using live data for our clients when accessing the reports over the app.
On a side note, is there any way I can test building for Power BI embedded to ensure my current reports are suitable?
Thanks
@WESTi wrote:
We have an app built on Microsoft SQL server. We are looking to use Power BI embedded for clients to view their specific information from our database via predefined reports that we have created.
A requirement of these reports is that we need to use the SUMMARIZE and GENERATE DAX functions in a DAX created table. This is not available in a direct query report that is built in Power BI desktop.
So my question is, when we switch to Power BI embedded, will we be limited by the direct query limitations - as in we cannot create DAX tables? I am trying to build our current reports in line with what will be suitable for Power BI embedded as I would like to directly transfer them. Also, it is obviously important that our reports are always using live data for our clients when accessing the reports over the app.
On a side note, is there any way I can test building for Power BI embedded to ensure my current reports are suitable?
Thanks
Power BI Embeded still uses the pbix created from Power BI desktop, which means no, you can't bypass the limitation. However as to "SUMMARIZE", I think you can somewhat achieve this in TSQL.
For live data, if it is SQL Server on-premises in your case, Power BI Embedded is obvious not a good option, Because at this moment, Power BI Embedded only supports direct query mode for Azure SQL database and Azure SQL Data warehouse.
By the way, just to confirm that, you're talking about this Power BI Embedded, right?