Forum Discussion
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 generate an output from a query against a Power BI dataset. With a test dataset containing a table named User email (Export), I have tried:
But the Actual Query was:
The keep getting error message like:
{
"error": {
"code": "DatasetExecuteQueriesError",
"pbi.error": {
"code": "DatasetExecuteQueriesError",
"parameters": {},
"details": [
{
"code": "DetailsMessage",
"detail": {
"type": 1,
"value": "Query (8, 40) Column '<oii>With activities</oii>' in table '<oii>User email (Export)</oii>' cannot be found or may not be used in this expression."
}
},
{
"code": "AnalysisServicesErrorCode",
"detail": {
"type": 1,
"value": "3241803780"
}
}
]
}
}
}
What is missing? Could anyone please help me?
Thanks,
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.
5 Replies
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.
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!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!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!
