Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Source Error. Please contact the gateway administrator

Hi All,

We have a report connected toSSAS and running fine for over an year. All of a sudden this morning the report is blank with the erro message. "There was a data source access error. Please contact the gateway administrator". Please advice.

Thanks

10 Replies

  • hey, 

    first to discard do a manual refresh on the pbix power bi desktop, if all fine, go over to your gateway and be sure its the laste version, out of date gateways can get this kind of problem, also check the specific error its getting when manually refreshing on the service. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      StefanoGrimaldi thanks. I am not getting any error when i do manual refresh, but the report is still blank. If the gateway is out of date, how come other reports in other workspaces are working fine? This is the ONLY workspace that used SSAS (SQL Server Analysis Services) as a source. The rest of the work spaces and the reports use other sources. I logged on to the server that hosts the on-premises data gateway and its version is 3000.31.3

      Thanks

       

      • StefanoGrimaldi's avatar
        StefanoGrimaldi
        Icon for Resident Rockstar rankResident Rockstar

        its out of date, on the configuration panel on the gateway in the server or pc you can upgrade it, well when its out a date can be certain conectors got changes (not all conectors get updates each time) and power BI service its waiting a certain response of the gateway but as its out of date and the service on date it can crash certain conections, try updating the gateway to the last version: 

         

  • Hi Anonymous 


    Can you check to make sure that the account you are using in the Gateway data source connection still works and is valid?

     

    I am going to take a guess that the password has changed.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks GilbertQ , the connection is successfull.