Forum Discussion
Run a query against a dataset syntax error
Multiple issues here. When running DAX queries you want to make them as simple and tabular as possible. Use a table visual without totals. Don't use a matrix visual as the basis.
Also, the ORDER BY clause is highly pointless and adds to the computational complexity. Omit that whereever possible.
Use the DAX Query View or DAX Studio to simplify your DAX code before transferring the query to Power Automate or other external query tools.
Multiple issues here. When running DAX queries you want to make them as simple and tabular as possible. Use a table visual without totals. Don't use a matrix visual as the basis.
Also, the ORDER BY clause is highly pointless and adds to the computational complexity. Omit that whereever possible.
Use the DAX Query View or DAX Studio to simplify your DAX code before transferring the query to Power Automate or other external query tools.