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,
I have created new tables using DAX from tables in the model. I want to merge two of the new tables.When I open Power Query Transform Data, I can't see the tables I have created. I see only the tables imported from data source.
How can I add these new tables to power query editor? If it is not possible, do you know a Dax command to do that?
Thanks in advance 🙂
Solved! Go to Solution.
You cannot. Power Query is a one way street - from source data to the data model. Objects like calculated tables and columns do not show up in Power Query. You have two options here.
#2 is not recommended. If it is a small model it won't matter, but if it is large, over 1M records, you will suffer from the lack of optimized compression calculated columns has. Your best bet is to always shape your data in Power Query or earlier, and leave the DAX model to just do analysis.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou cannot. Power Query is a one way street - from source data to the data model. Objects like calculated tables and columns do not show up in Power Query. You have two options here.
#2 is not recommended. If it is a small model it won't matter, but if it is large, over 1M records, you will suffer from the lack of optimized compression calculated columns has. Your best bet is to always shape your data in Power Query or earlier, and leave the DAX model to just do analysis.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin 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.