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 ...
Need Help
  • 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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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!