Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I was playing around with the Query View in Power BI Desktop. I wanted to create a table from scratch without importing from any source and then I wanted to show output of the table also perform some calculations on it later. I thought of using Table Constructor first but as it doesn't allow to give names to the columns directly so I used DATATABLE instead. I tried to run this query in the Query View:
Solved! Go to Solution.
It;s a known limitation/bug. DAX Query View only works if you include at least one artifact from the existing data model.
It is not mention clearly in the below link that "DAX Evaluate queries work only on databases which have at least one tables."
DAX query view in Power BI Desktop - Power BI | Microsoft Learn
But for now it is limitation, that DAX Query View only works if we inculde atleast on entity/table.
It is not necessary to mention any artifact from existing data model.
I hope you find it helpful.
Thanking You!
It is not mention clearly in the below link that "DAX Evaluate queries work only on databases which have at least one tables."
DAX query view in Power BI Desktop - Power BI | Microsoft Learn
But for now it is limitation, that DAX Query View only works if we inculde atleast on entity/table.
It is not necessary to mention any artifact from existing data model.
I hope you find it helpful.
Thanking You!
It;s a known limitation/bug. DAX Query View only works if you include at least one artifact from the existing data model.
Hi,
I'm already going through the documentation (Query View). Can you please provide some kind of citation?
Ask Zoe or Amanda.
User | Count |
---|---|
51 | |
35 | |
19 | |
15 | |
14 |
User | Count |
---|---|
94 | |
80 | |
37 | |
22 | |
18 |