March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi There,
new to Power BI and looking for a little help/advice on this error.
we have 2 different reports created in Desktop, 1 is using direct Query, and the other Import for the data. the tables and relationships in the 2 reports are the same
we have added the same measure to both. in the report using Direct Query we get the error above. wondering if it is something to do with using Direct Query or not?
thanks in advance
Solved! Go to Solution.
I think switching to import should be the last resort, I'd suggest rewriting current syntax using DATEADD to something using e.g. FILTER etc. - if possible
can you share the syntax that gives the error & the structure of the tables included?
is it time intelligence related measure? they do not work in Direct Query
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery
https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-d...
Hi Stachu,
thank you for the response.
we are using DATEADD, so by your response we would need to swith the mode to Import to get use of these?
many thanks
scott
I think switching to import should be the last resort, I'd suggest rewriting current syntax using DATEADD to something using e.g. FILTER etc. - if possible
can you share the syntax that gives the error & the structure of the tables included?
Hi Stachu,
many thanks ill look into re-writing it.
good luck 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
132 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
203 | |
141 | |
107 | |
73 | |
70 |