Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
13 | |
11 | |
8 | |
8 | |
8 |