SAP BW Gateway Refresh - Table DIMENSIONS contains 0 fields. Index 0 is out of range

[Anonymous]

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. 

• I've tested the gateway connection and it's working.
• Other reports that target Sap are refreshing correctly.
  • It looks like I'm having issues with queries that target dimension tables such as Plant, Customer, etc. 
• I downloaded the report and refreshed through desktop without any issues
• I've verified that our gateway didn't get patched recently
• I've verified that the reports run correctly from SAP BW. 
  • 

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? 

[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:

• Set Privacy Level to Organizational
• Made sure all reports are refreshed at different times
• Created another on-premise gateway to split the load
• Ensured both desktop and gateway has the latest version installed at all times

[Anonymous · Accepted 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