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 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

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