Forum Discussion
Does Power BI import everything before aggregating with Direct Query?
It looks like the issue was with the complexity of the Query Editor operations? I removed one of the steps which was "remove column" that someone added and it works now...
I did find this in the documentation to support it:
"If the Query Editor query is overly complex, an error will occur. To remedy the error you must either delete the problematic step in Query Editor, or Import the data instead of using DirectQuery. For multi-dimensional sources like SAP Business Warehouse, there is no Query Editor"
Not too sure at this point why the remove column step was problematic but I can work with this. Hopefully this'll help others if they run into this issue.
I appreciate your help Anonymous !
Anonymous - Is there a Relationship defined between the 2 tables?
Anonymous Yes there is, I just checked to make sure.
With DirectQuery, the DAX needs to be translated into the data source's query language (SQL). So you could run a trace on the source DB to find out what SQL is being run.
What is the DAX of the Measure used to count rows? And what is the SQL that it is converted into?
It looks like the issue was with the complexity of the Query Editor operations? I removed one of the steps which was "remove column" that someone added and it works now...
I did find this in the documentation to support it:
"If the Query Editor query is overly complex, an error will occur. To remedy the error you must either delete the problematic step in Query Editor, or Import the data instead of using DirectQuery. For multi-dimensional sources like SAP Business Warehouse, there is no Query Editor"
Not too sure at this point why the remove column step was problematic but I can work with this. Hopefully this'll help others if they run into this issue.
I appreciate your help Anonymous !