Dataset transform are empty

[HugoFrauches]

Hello everyone,

Currently i have connected to a dataset hosted on powerBi service, after working around to enable DirectQuery to datasets on the desktop version i was able to click on the Transform button, but when i ry to transform the data there is no queries (Screenshot), i can see the tables on the Desktop app but there isnt query on Transform Data.



There is any workaround to do it? Do i need to transform the dataset to a dataflow to make it?

[HugoFrauches]

Hello Amit,

Thank you for the reply, there is any other way to transform this data? Should i consume this data on a AzureSQL or other solution?

[Syndicate_Admin]

I have the same problem as you. What I have done is export the data with DAX to an excel and upload it back to a Power BI to be able to transform the data.

[amitchandak]

@HugoFrauches , seem like by design
https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-servic...
"The connection to a Power BI dataset will not be shown in Power Query."