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.
Hi All,
From last Monday onwards, I am unable to refresh any of the Power BI reports that takes data from Octane using OData. The following error is getting while refreshing the data from Power BI Service as well from Power BI Desktop.
"DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (The number of phase transitions currently read 5332, exceeds the allowed limit 4000. Apply a filter to reduce the number of displayed items or increase the value of the parameter MAX_NUM_OF_MODIFIED_FIELD_AUDIT_RECORDS_TO_FETCH.)". Can anyone help me out of this?
Thanks in Advance
Hi @_123 ,
The error message tells you very clearly what the problem is, and I think you need to check this message.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @v-mengzhu-msft, I checked that message but I couldn't find any option to reduce the displayed items or increase the value of the parameter. If you know, could you please help me on the same?
Hi @_123 ,
Can these contents help you?
Changes to applying filters to reduce your number of queries (wiseowl.co.uk)
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@v-mengzhu-msft The issue is not with the slicer or visualization, rather the problem is facing when we import data from datasource. After importing/refresh the data the above mentioned errpr is showing. Is any way to reduce the display parameters, when we import data to Power Query?
That sounds more like an issue with your Octane database server? Have you checked with the DBA?
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 |
---|---|
50 | |
18 | |
16 | |
16 | |
8 |