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.
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!