Forum Discussion
Dataset transform are empty
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?
3 Replies
HugoFrauches , seem like by design
https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/
"The connection to a Power BI dataset will not be shown in Power Query."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?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.
