Forum Discussion

Anonymous_10's avatar
Anonymous_10
Frequent Visitor
1 year ago
Solved

Run a query against a dataset syntax error

Hi Team, I needed to export data from power bi semantic model to a SP list. So I tried to use Run a query against a dataset actio n but I keep getting error.I am trying to get Power Automate to gene...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous_10 ,

I trust the lbendlin response is accurate and will address your issue.

If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.

If the answer meets your requirements, please consider marking it as Accept as solution.

Thank you for being a valued member of the Microsoft Fabric Community Forum!