Reply
Highlighted
Frequent Visitor
Posts: 8
Registered: ‎10-17-2018
Accepted Solution

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!

 

 


Accepted Solutions
Moderator
Posts: 10,201
Registered: ‎03-10-2016

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


All Replies
Moderator
Posts: 10,201
Registered: ‎03-10-2016

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.
Frequent Visitor
Posts: 8
Registered: ‎10-17-2018

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!