Power Automate - Building Flows

Answered

Power BI: Run a Query Against a Dataset

Like (0) Share

Report

Posted on 2 Jun 2022 14:23:48 by TesDA

611

I'm getting a strange error:

{"error":{"code":"DatasetExecuteQueriesError","pbi.error":{"code":"DatasetExecuteQueriesError","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"Query (18, 3) A single value for column 'Location' in table 'PS_Org_Emp' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."}},{"code":"AnalysisServicesErrorCode","detail":{"type":1,"value":"3241803789"}}]}}}

In power bi I have a relationship set, so it only provides a single value. Location is not a calculation, it is simply the Location. So I don't totally understand why this error is being triggered. Also, I have two other columns from that table that are working fine, so I don't understand why this one would trigger an error.

This is my query:

EVALUATE SUMMARIZECOLUMNS(
PS_Emp[Name], "Name",
PS_Emp[USID], "USID",
PS_Emp[Hire Date], "Hire Date",
PS_Emp[Rank], "Rank",
PS_Emp[Title], "Title",
PS_Emp[FlexTrack], "FlexTrack",
CALCULATE(sum(PS_Emp[Work Hours in Year])/2080), "FTE",
PS_Org_Emp[Market], "Market",
PS_Org_Emp[LLC LLP], "LLC LLP",
PS_Emp[Specialty], "Specialty",
PS_Emp[ECS ICS], "ECS ICS",
PS_Emp[Coach], "Coach",
PS_Emp[Solution Family], "Solution Family",
PS_Emp[SL], "Sub Solution Family",
PS_Emp[NonDCBased], "NonDCBased",
PS_Emp[CTL], "CTL",
PS_Org_Emp[Location], "Location",

FILTER(PS_Emp, PS_Emp[Status] = "Active" &&
PS_Emp[Title] <> "Partner" &&
PS_Emp[Employee Class] <> "BRWDRESORCE" &&
PS_Emp[Employee Class] <> "SUBCONTRACT")
)

In the power bi data, PS_Emp relates to PS_Org_Emp based on a one to many join:

PS_Emp:

Employee ID | Organization ID

98765 | 1.1.15

67890 | 1.1.10

34567 | 1.1.15

PS_Org_Emp

Organization ID | Location | LLC LLP | Market

1.1.15 | Baltimore, MD | LLC | Ag

1.1.10 | Boston, MA | LLC | Cereal

I have the same question (0)

All responses (6)

Answers (1)

xariet 2 on 30 May 2024 at 03:50:48

Like (0)

Report

Re: Power BI: Run a Query Against a Dataset

@Chouyeuh what kind of settings I need to ask admin to turn on?

Was this reply helpful? Yes No
Chouyeuh 2 on 31 Aug 2023 at 13:10:37

Like (0)

Report

Re: Power BI: Run a Query Against a Dataset

Mine was because the setting turned off by admin of my company, if you're working in a company you can request to turn it on for you.

Was this reply helpful? Yes No
BQueen 2 on 31 Aug 2023 at 08:55:58

Like (0)

Report

Re: Guys please help to deal with this error

I am having this same error, we’re you able to figure out how to fix this?

Was this reply helpful? Yes No
chouyueh 19 on 27 Jul 2022 at 08:07:08

Like (0)

Report

Re: Power BI: Run a Query Against a Dataset

I am having an error 'DatasetExecuteQueries' is not enabled for the tenant. as well, can anyone explain what is the root cause? I am extracting data from my own workspace

Was this reply helpful? Yes No
sravula 2 on 22 Jul 2022 at 11:30:09

Like (0)

Report

Guys please help to deal with this error

{
  "error": {
    "code": "PowerBIFeatureDisabled",
    "pbi.error": {
      "code": "PowerBIFeatureDisabled",
      "parameters": {},
      "details": [
        {
          "code": "DetailsMessage",
          "detail": {
            "type": 1,
            "value": "'DatasetExecuteQueries' is not enabled for the tenant."
          }
        }
      ],
      "exceptionCulprit": 1
    }
  }
}

Was this reply helpful? Yes No
Verified answer

TesDA 611 on 03 Jun 2022 at 15:30:12

Like (1)

Report

Re: Power BI: Run a Query Against a Dataset

If you use Performance Analyzer on the View tab of Power BI Desktop and run a recording, it will provide the code for the visual you need. So much easier then I thought

Was this reply helpful? Yes No

Community site session details

Power BI: Run a Query Against a Dataset

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Power BI: Run a Query Against a Dataset

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates