Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX - Power Automate Power BI Connector: Run a Query Against a Dataset

I'm posting here because I suspect the issue is with my DAX - SUMMARIZECOLUMNS()   I'm getting a strange error:  {"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQu...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I ws able to solve this by running the Perf Analyzer and coping the code for the visual that needed to be recreated. Much simpler then I had originally thought. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Your sample data is missing the filter columns and the aggregated fact column.  Based on the limited data you provided this query will work:

EVALUATE SUMMARIZECOLUMNS(
PS_Emp[Employee ID],
PS_Org_Emp[Market], 
PS_Org_Emp[LLC LLP], 
PS_Org_Emp[Location]
)

 

Note that the syntax for SUMMARIZECOLUMNS() is slightly different than what you tried to use.

 

 

Please provide sanitized sample data that fully covers your issue.

Please show the expected outcome based on the sample data you provided.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I ws able to solve this by running the Perf Analyzer and coping the code for the visual that needed to be recreated. Much simpler then I had originally thought. 

  • VuongLM93's avatar
    VuongLM93
    Icon for Helper III rankHelper III
    4 years ago

    I have also an issue - does this flow not work for Live connection.  (dataset from someone in the organization created, I just have the live connection )