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
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.
2 REPLIES 2
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.
Highlighted
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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 41 members 1,105 guests
Please welcome our newest community members: