Showing results for 
Search instead for 
Did you mean: 
saunders Regular Visitor
Regular Visitor

SAP BW refresh using on-premise data gateway

Hi all,


Wondered if anyone can help with the following scenario:


  1. Added our on-premise SAP BW as a data source to our on-premise data gateway (connectivity is successful)
  2. Imported data from SAP BW to PBI desktop, publish to service
  3. Report and data appear fine in
  4. After manual or scheduled refresh, the visuals are empty of data, i.e. the data disappears and the visuals contain no data.  I can still see the tables in the dataset, but there are no values when adding columns to a visual.


There is clearly a problem with the refresh through the gateway, i.e. there is connectivity but no data.

Can anyone confirm what specific permissions the gateway credentials need to have in BW to get the data?  For example, to connect and retrieve data from SQL Server, the gateway user requires server admin permissions.  Is it the same with BW?


Thanks in advance,

Community Support Team
Community Support Team

Re: SAP BW refresh using on-premise data gateway

Hi @saunders,


>>For example, to connect and retrieve data from SQL Server, the gateway user requires server admin permissions.I think the issue is not caused by the permission, if your connection is active it means you already have the enough permission to operate the datasource.


In addition, you can try below methods to ensure the issue.


1. Check if issue is related to datasource.

Re-create a datasource and test again.


2. Check if the issue is related to gateway/database.

Add a new type database to test.


3. Check if the issue is related to network connection.
Change a stable network to test.



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Helpful resources


How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 42 members 1,053 guests
Please welcome our newest community members: