Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to build a live report from azure sql database with the direct query option. But directquery does not allow me to manipulate data(This step results in a query that is not supported in DirectQuery mode). Can I still build a live report? And how can I go about doing it
Hi @weilip1803,
As no data is imported or copied into Power BI, DirectQuery is suggested for users who are familiar with the databases and entities they connect to. In Power BI Service, you can drag query out fields into visuals, data modeling are not available.
In your scenario, if you want to perform data modeling and data transformations for those fields, the suggestion is to use DirectQuery in Power BI Desktop. Then publish the .pbix file to Power BI Service. For more information, please refer to links below:
Azure SQL Database with DirectQuery
Use DirectQuery in Power BI Desktop
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Live query currently does not support the full set of transformations that you can do with an imported query. I have the impression that they are working on adding more transformation functionality to direct query connections but for now you can't use it if you need those complex transformations. For now I just have my reports set to auto-refresh several times a day and my users know that their data is only accurate to within the last three hours.
Proud to be a Super User!
@weilip1803 I'm not sure if I understood you 100%, but using power bi service you can connect to azure sql db using directquery but that will not give you data modelling part that you get in power bi desktop. You can still build reports but just as you mentioned you can't do complex data transformations that you are able to do in power bi desktop.