Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.