Forum Discussion

ravindranraman's avatar
ravindranraman
Regular Visitor
4 years ago

Error refreshing data thru PBI app

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

 

 

Need Help

4 Replies

  • nitishsh91's avatar
    nitishsh91
    Solution Supplier
    4 years ago

    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's avatar
      ravindranraman
      Regular Visitor
      4 years ago

      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's avatar
        nitishsh91
        Solution Supplier
        4 years ago

        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.