Forum Discussion
Separate data itself from a data model
Hello, I have been wondering if it would be possible to achive a situation in Power BI Service, where I have one main data model (relationships, measures, metadata) but without data itself? What ...
Hi TomasDo
As far as I know what you want to do is to use DirectQuery to your Azure SQL?
If so this should be able to be done, but just note that every single visual on a page will send a query down to your Azure SQL which could get very busy and potentially reports could also be slow.
I would recommend then using dataflows to refresh the individual tables, and then you would still need to import the data into your main data model and have that refreshing.