Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Report a bug on Power BI Desktop OData Connector

Hello teams,

 

I have had try to use the latest version of Power BI Desktop (Version 2.92.706.0) to get Azure AD Users’ information by calling Azure AD Graph API: “https://graph.windows.net/Tenant ID/users?api-version=1.6” via OData connector. However, I have met the below error:

 

JeffZhu_0-1620887510705.jpeg

 

Error detail:

JeffZhu_1-1620887510729.png

 

I use fiddle to grab the request from Power BI Desktop and compare it with the request from Azure AD API explorer, got the below information:

Request from Power BI Desktop OData Connector

JeffZhu_2-1620887510741.png

 

 

Detail: https://graph.windows.net/a2486d92-68be-49af-96ec-3aca3f969cf6/directoryObjects/$/Microsoft.Director...'

 

Request from Azure AD explorer

JeffZhu_3-1620887510753.png

 

 

Detail: https://graph.windows.net/a2486d92-68be-49af-96ec-3aca3f969cf6/directoryObjects/$/Microsoft.Director...

 

Based on Azure AD Graph API Document (https://docs.microsoft.com/en-us/previous-versions/azure/ad/graph/howto/azure-ad-graph-api-versionin...)

“You must specify the version of an operation that you want to use by including the api-version query string parameter in your request. Requests without an api-version parameter will be rejected and return a (400) Bad Request response. ”

JeffZhu_4-1620887727248.png

 

Regarding the above information, the issue is caused by the Power BI Desktop OData request lake of the suffix of API version when requesting the OdataNextLink.

 

I also test the behavior on Power BI Desktop (Version 2.91.884.0), and the result is normal. So the issue only happened on the latest version (2.92.706.0) of Power BI Desktop.

 

Please notice PG fixes this bug.

Status: New
Comments
JeffZhu
Employee

Update new finding

The issue happened on all versions of Power BI Desktop but only happened with the advanced mode of the OData connector. 

 

JeffZhu_2-1620897160990.png

 

The query will lake of "Query=[#"api-version"="1.6"]"

JeffZhu_1-1620897060662.png

 

The OData Connector didn't automatically recognize the version of API when using the advanced mode.

 

v-lili6-msft
Community Support

hi

please have a look this document:

Connecting to Microsoft Graph

Connecting to Microsoft Graph REST APIs from Power Query isn't recommended or supported. See this article for more information.

 

https://docs.microsoft.com/en-us/power-query/connecting-to-graph

 

 

Regards,

Lin