Forum Discussion
Post PartisanRefresh failing in Service
Hi All,
I have a report which is connected to SAP BW BEx query as a source. The report refresh works fine in Desktop version, but the refresh fails on Service. There a a couple of tables used in the report, and everytime it fails with a different table name.
Can someone please suggest on how this can be fixed.
Thank you.
1 Reply
Hi, POSPOS
When using Power BI, some SAP BW features aren't fully supported or behave differently. This includes local calculations, aggregations, currency formats, and more. These differences may not cause issues with the desktop, but they can cause service refreshes to fail. Take a closer look at the limitations and behavioral differences to make sure you're correctly interpreting the results viewed through Power BI. More details can be found here:
DirectQuery and SAP Business Warehouse (BW) in Power BI - Power BI | Microsoft Learn
The Power BI service has limits on the duration and frequency of scheduled refreshes. If the data source takes a long time to refresh or has a large amount of data, it can cause timeouts or failures. Consider optimizing your report to speed up refresh times, or break it down into smaller pieces.
Ensure that the credentials used for the SAP BW source in the Power BI service are set up correctly and have the necessary permissions. Incorrect or expired credentials can cause refresh failures.
Power BI attempts to optimize data retrieval by "collapsing" queries back to the source system. If query folding doesn't happen as expected, it can lead to inefficiencies and potential refresh issues. While this is more relevant to Power Query transformations, it's worth making sure your queries are optimized for performance.
The error message mentions a specific table "Table_CCTO". Check if this table exists in the database and if the user has the necessary permissions to access this table. The error message also includes "SAP Business Warehouse: Object reference is not set to an instance of an object". This indicates that there may be a null reference error. Check the query and data source to make sure there are no null references.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
