Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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,
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |