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 
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved. If our answer resolved your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.If you need any further assistance, feel free to reach out.

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

  • Anonymous_10's avatar
    Anonymous_10
    Frequent Visitor
    1 year ago

    Hi Anonymous 
    Sorry for delay in my response. I have been out of the town and I marked "accepted" for the solution provided by lbendlin .
    Thanks for the prompt response lbendlin and Anonymous thanks for the follow up.