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.
Hi,
I have a Power bI report using SQL server DB tables and few other data sources [Data Ware house]. I am trying to migrate data connection to Azure Analysis Services [AAS]. I started using Live connection-> Direct Query and selected the 7 tables I need. I could successfully make the connection. But I am having challenge in next step!
The existing report adds "Transform Data" steps [Add new Columns from an existing Col, Merge with another table, etc.] to almost all of the 7 tables. Here is one set of steps for 1 of the tables:
The existing report also builds new datasets from some of these 7 tables.
-My question is how do I implement these "Data Transform" steps in Direct Query mode using AAS? Direct Query doesn't allow me to see the "Data" view or allow any of the "Data Transform" steps on the tables.
Many thanks in advance.
Hello @sohananahid ,
You could copy the M code for the steps from the advanced editor as in the screenshot.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hi @Idrissshatila - even I have some M code from the existing report which uses "Import" mode for data connection, but now with "Direct Query"- I can't access those datasets if I try "Transform Data", hence can't paste the M code! Did you find a way to access the connected datasets [via Direct Query] in "Transform Data"? Thanks.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
119 | |
104 | |
77 | |
69 |