Forum Discussion

Marcin's avatar
Marcin
Helper V
9 years ago

Gateway change

Hi,

I publish report made in Power BI desktop, with Import connection type, to my company service. Next I need to change gateway from this installed on my computer to another one where data source analysis services is running.   I have this problem,  whene I try to schedule refresh for this report, the error message says that I have no access to this Analysis Services, but the credentials in Data Source Setting are good for sure, I think that it is using my before credentials instead of those from Data Source Setting. 

 Connection test is successful. 

My workmate who has access to this data source does not have this problem. 

Please help

 

Need Help

5 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi Marcin,

    If you change the data resource, you need to add a new data reource in your gateway. Please see the following screenshot. Click ... in your gateway->Add Date source-> Type your credentials.



    If set the Data Source, and connect it successfully, while you can not create a report refresh? In desktop, you also set the data resource by clicking the file->Date resource settings? Please check it if it wroks fine after set data resource both service and desktop.

    Best Regards,
    Angelia

    • Marcin's avatar
      Marcin
      Helper V
      9 years ago

      As Data Source I always use local ( in Desktop and Online serivce ), so I think there no need to change to source

       

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi Marcin,

        Have your changed your computer account or password? I think you use the windows authentication to connect your SSAS right? If you have changed account or password, please update in your Date resource settings.

        Thanks,
        Angelia