Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have some tables imported from different sources into Power BI using M. I have only learnt DAX expressions propoerly till now. I created a new table using DAX expressions directly.
Now, I am trying to write a M query but I am not sure how to import the table that I created using DAX.
I used Source = #"Table1". But it recognizes Table1 only if it was created using M. It doesn't recognize the one created using DAX.
Solved! Go to Solution.
Actually it is possible! But in a really round about way which I don't recommend.
Using Get Data use can specify Analysys Services as your source. If you have DAX Studio you can find the port number your PBI Desktop model is listening on. Simply connect to Localhost:63410 (or whatever port number your model is currently on)
You can then use your DAX tables as data sources to import in. Each time you open/close PBI Desktop the port number will change and you'll have to manually update it which is where it falls apart.
So it's ok for one off work but no good in reality. Mostly interesting.
Query Editor to DAX is a ONE WAY street!
Meaning DAX created tables are NOT accessible in the Query Editor!
Actually it is possible! But in a really round about way which I don't recommend.
Using Get Data use can specify Analysys Services as your source. If you have DAX Studio you can find the port number your PBI Desktop model is listening on. Simply connect to Localhost:63410 (or whatever port number your model is currently on)
You can then use your DAX tables as data sources to import in. Each time you open/close PBI Desktop the port number will change and you'll have to manually update it which is where it falls apart.
So it's ok for one off work but no good in reality. Mostly interesting.
Thanks for the workaround. For this time I will rewrite my queries. But it might come in handy when there are too many queries to be rewritten.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |