cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RohitCelur
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
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 Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Highlighted
RohitCelur
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

 

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 Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors