Odata Feed (Intune) not loading in Power BI

[Anonymous]

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!

[v-yuezhe-msft · Accepted solution]

@Anonymous,

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

[Anonymous]

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