Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
We've been refreshing reports that target SAP BW for sometime without any issues. Starting this morning I had several reports error out do to the following error "Table Dimensions contains 0 fields. Index 0 is out of range" and the data source is SapBusinessWarehouse.
Here is the refresh history for the last several days. You'll see that we haven't had any issues till today. Same error in all three attempts.
At this point I'm out of options. Is anyone else having issues? Did something change on the server last night?
Suggestions?
Solved! Go to Solution.
I ended up opening a ticket with MS and while we never actualy deteremined what the issue was it does seem to have been something to do with the gateway. As a part of reviewing the issue with MS we had to enabled logging on the gateway. Enableing logging required a restart of the gatway and after that evertything started working as expected. So this is no longer an issue.
The part that is confusing is that only certain types of SAP BW queries were failing. Queries going agasint cubes worked but queries that targeted master data (or dimensions such as plant, material, etc.) would fail. So this issue was not issolated to a specific source system.
Needles to say this is no longer an issue and going forward we'll make sure to bounce/restart the gatway or even the gateway server should we ever encounted this error prior to making a post or opening a ticket with MS.
Thanks for the suggestions @v-diye-msft
Hi @Anonymous
Does this issue also happen in power bi desktop? If this issue only happens in power bi service, please check if there's something wrong with the schedule refresh configuration and credentials.
You may want to try all the things we have tried in case that helps:
I ended up opening a ticket with MS and while we never actualy deteremined what the issue was it does seem to have been something to do with the gateway. As a part of reviewing the issue with MS we had to enabled logging on the gateway. Enableing logging required a restart of the gatway and after that evertything started working as expected. So this is no longer an issue.
The part that is confusing is that only certain types of SAP BW queries were failing. Queries going agasint cubes worked but queries that targeted master data (or dimensions such as plant, material, etc.) would fail. So this issue was not issolated to a specific source system.
Needles to say this is no longer an issue and going forward we'll make sure to bounce/restart the gatway or even the gateway server should we ever encounted this error prior to making a post or opening a ticket with MS.
Thanks for the suggestions @v-diye-msft