Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Issue with dataset refresh - The last refresh attempt failed because of an internal service error

Hello,

 

Since 7/30, my dataset refresh appears to be refreshing with all my data, however, I receive the following message:

 

"The last refresh attempt failed because of an internal service error"

 

Is there something going on with Microsofts servers/data center?  Is there a status page that could be checked to see if there're any issues?

 

Below is a sceenshot of the error:

 

 

Thank you

 

 

 

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    I'd like more detailed information to help us clarify your scenario. For example: datasource type, connection mode, credentials type, detail error message and gateway refresh logs.

     

    Troubleshooting the On-premises data gateway

    Spoiler

    Installer logs

    %localappdata%\Temp\On-premises_data_gateway_*.log

    Configuration logs

    %localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.log

    On-premises data gateway service logs

    C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log


    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Xiaoxin,

       

      Absolutely, below are the answers to your questions:

       

      • Datasource type - Azure SQL Data Warehouse
      • Connection mode - SQL user login
      • Credential type, same as above
      • Detailed error message:

               

        

      Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
      Activity ID:f67268a1-08fc-4f94-98ad-51ad64cdafae
      Request ID:429602c2-715f-4a70-8b56-9a8910f97be1
      Time:2018-08-02 12:14:44Z

       

      Please note, there is no gateway since the source is Azure SQL Data Warehouse talking to Power BI.

       

      Thank you,

      Peter

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI Anonymous.

         

        If you download this pbix file and refresh on desktop side, does this works?

         

        Regards,

        Xiaoxin Sheng