Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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!

 

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

      Anonymous,

       

      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!