Error refreshing data thru PBI app

[ravindranraman]

Hi All,

Anyone is encountring the error below and is there a fix for it? This is happening everytime a data refresh needs to happen. Even forced refresh does not work but works well when refreshed directly on the desktop.

Underlying error code: -2147467259
Underlying error message: We're sorry, an error occurred during evaluation.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Cluster URI: WABI-US-NORTH-CENTRAL-C-PRIMARY-redirect.analysis.windows.net
Activity ID: fce8599a-7e99-45da-9f06-3177133733dc
Request ID: 6f75e6d9-3df2-1b56-945a-294c47f72ae1
Time: 2022-09-01 00:41:37Z

[nitishsh91]

Hi @ravindranraman 

Some more info is needed to further suggest on this issue:

• In which workspace is your report hosted? Standard or premium?
• Is this issue happening with other reports or just one report?
• Did you try publishing this dataset to some other workspace and see if the issue still persists?
• Has this report ever refreshed on the service?
• What are the data sources of this report?
• Are you using any gateway for report refresh? If yes then what version.

Please note that there are no known issues which might be causing this so need to understand a bit more.

[ravindranraman]

Hi @nitishsh91 

• In which workspace is your report hosted? Standard or premium? Pro
• Is this issue happening with other reports or just one report? All Reports
• Did you try publishing this dataset to some other workspace and see if the issue still persists? Tested with Same error
• Has this report ever refreshed on the service? It was working fine until 30th August then started to fail
• What are the data sources of this report? from SQL server, works fine when refreshed thru desktop
• Are you using any gateway for report refresh? If yes then what version.

[nitishsh91]

Hi @ravindranraman 

Please can you check if you are able to connect to the database from the server where you powerbi gateway is installed by doing telnet or directly via ssms, it looks like some change in firewall has cuased this issue, also check if the account that's being used for connecting to sql database is still working or not.

[ravindranraman]

Hi @nitishsh91 , seems this has been automatically fixed. The refresh is working as per normal