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 con...
Need Help
StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
5 years ago

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
    5 years ago

    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
      5 years ago

      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: 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks StefanoGrimaldi , can you please post the link to download the latest version? Is there a way we can set it to auto update whenever a new version is out there?