How to create a new table in PBI Direct Query mode since we don't have the access to query editor.

[Anonymous]

Can I create a whole new table in direct query mode? The data is coming from AAS server. I wanted to create the Refresh Table which has all the date and time columns showing details of last refreshes.

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Please take a look at the document about composite models.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models .

You could combines import data and the data from DirectQuery sources.

Best Regards,

Jay