Ever wanted to know what the data source is for a DirectQuery table in your Power BI composite model?
I have not found an easy way to check this. Using Tabular Editor however, it can be done. Follow the steps below.
Open tabular editor → connect to the semantic model you want to inspect → right click on the table you are interested in → Script → Create or Replace → To clipboard → Paste somewhere → Scroll all the way down and voila.
Another way to do this is using SQL Server Management Studio. That is a subject for another post though.
Bezig met laden…
Laad het document opnieuw 
Openen in nieuwe tab