cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

PowerBI refresh issue! Need Help

Hello All,

 

We are facing an issue while refreshing the PowerBI reports. The source connection in SAP BW (Bex Query) - Import data and we are able to successfully refresh the report on PowerBI desktop. However, once we publish the report, and refresh we see the below error:

 
 

Error.PNG

Already verified that the gateway connection is properly setup and also tested using a different Bex query (SAP BW) as the source (same server and gateway connection) and the report refreshes without an error.

Also tried refreshing the reports with a reduced dataset (included addition filters) but doesn't help.

Please guide.

 

Thank you,

Rohit

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: PowerBI refresh issue! Need Help

HI @RohitCelur ,

Any changes applied on your table that you masked on snapshot? (data structure change: column name/type, add or remove columns, rename or delete table)

I'd like to suggest you double-check on your database to confirm if its data structure changes. (Power query will cache data structure to query steps. If new records' data structures do not match with cached, it will show an error about 'key not matches')

In addition, you can also check your credentials and connection string that config in the gateway to confirm they are same with your configured on desktop side.

Power BI Web Refresh issue: Expression.Error 

Regards,
Xiaoxin Sheng

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

Re: PowerBI refresh issue! Need Help

Hello,

 

Thank you for your reply. I have made all these checks and they seem fine. The BW Source (BEX query) is a copy of another query with additional filter conditions - when we use the original query, the refresh happens properly but when we use the copy, we run into the issue that i mentioned. Is there any specific change / property that needs to be set?

Also, I have created a new file to import data using the original query and tested its refresh capabilities - it succeeds both on desktop and service. The copy query however refreshes in the desktop and not in the service.

 

Thank you,

Rohit

 

Highlighted
Community Support
Community Support

Re: PowerBI refresh issue! Need Help

Hi @RohitCelur ,

Have you used the same credentials on these query tables?(both original version and backup)
if you are using different credentials, please double check on your database if there are any security or permissions setting on credentials to limit queried fields.
Regards,

Xiaoxin Sheng

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors