- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

Error code PowerBINotAuthorizedException while using new Power BI REST APIs for DAX queries
Hi,
I have successfully started to use the new support for DAX query using Power BI Rest APIs.
However I have encountered an issue which seems to be undocumented.
Authenticating using a service principal (AAD application) and querying a Power BI dataset which uses mixed mode (DQ to PBI dataset) returns an error 401 unauthorized PowerBINotAuthorizedException.
The very same REST API call to a dataset which does not have mixed mode, i.e. only import, works fine.
The dataset which causes issues has a DQ to a remote Power BI dataset in mixed mode. Using the New functionality DirectQuery for Power BI datasets. The very same REST API call directly to the remote dataset works OK.
The AAD App has proper API permissions for Power BI Service (Dataset.Read.All). Service principal have Admin permissions in both remote Power BI dataset workspace as well as on the workspace where the querying dataset is located.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-
Gionedis
on: Copying Table with Filters is Ignoring Filters
- tbuck on: March 2025 Update - Error fetching data for this v...
- rschimmel on: Snowflake connector isn't showing views after Marc...
- Tomasz_Skoczyla on: March 2025 update - Style preset error
- AKamyar1 on: Conditional Formatting - Field Value not working a...
- njf on: Stretched App's Logo in Home Page "Recommended"
- pedrodr99 on: Button Slicer - Label - Color change not working
-
v-xiaoyan-msft on: Default Chart - Shape Map Is Not Working As Expect...
-
v-xiaoyan-msft on: Error (Exception from HRESULT: 0x80070002)
-
v-xiaoyan-msft on: Card (new) - SVG images dont render correctly
- New 7,869
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,148 -
Data Modeling
4,092 -
Dashboards
4,081 -
Gateways
2,103 -
Report Server
2,098 -
APIS and Embedding
1,949 -
Custom Visuals
1,770 -
Content Packs
521 -
Mobile
353 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1