cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
acartobia Frequent Visitor
Frequent Visitor

Odata Feed (Intune) not loading in Power BI

Hello,

 

I am connecting to Microsoft Intune via Odata connector in Power BI. 

It doesn't have any problems with other tables, but : "devicePropertyHistories" table just can't load.

I have tried to refresh on desktop as well as on PowerBI Service without any results. 

 

- On the Service I got this error message:

        "OData: Request failed: The operation has timed out Table: devicePropertyHistories."

- On desktop I've tried to refresh each table at a time and it worked for every table, but the mentioned one. 

 

I have tried the beta and the v1.0 for Intune, but I've got the same result.

 

I would really appreciate any help on this issue. 

Thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Odata Feed (Intune) not loading in Power BI

@acartobia,

Increase timeout interval manually in the M codes of Advanced Editor and check if you get still get errors. There is an example for your reference.

let
    Source = OData.Feed("YourURL ", [Timeout=#duration(0, 0, 30, 0)])
in
    Source


If the issue still occurs, consider to enter Odata link for devicePropertyHistories table by filtering in the URL on the column and rows.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Odata Feed (Intune) not loading in Power BI

@acartobia,

Increase timeout interval manually in the M codes of Advanced Editor and check if you get still get errors. There is an example for your reference.

let
    Source = OData.Feed("YourURL ", [Timeout=#duration(0, 0, 30, 0)])
in
    Source


If the issue still occurs, consider to enter Odata link for devicePropertyHistories table by filtering in the URL on the column and rows.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

acartobia Frequent Visitor
Frequent Visitor

Re: Odata Feed (Intune) not loading in Power BI

@v-yuezhe-msft,

 

I've tried the solution you mentioned, but I've got an error regarding "duration", like it wasn't identified and good M sintax.

 

Anyway, now it works for some reason that I actually don't know for sure.

 

Thanks for your reply!

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 434 members 4,185 guests
Please welcome our newest community members: