Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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.
@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."
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
82 | |
65 | |
63 | |
56 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |