Forum Discussion

paulob_involves's avatar
paulob_involves
Icon for Advocate I rankAdvocate I
8 years ago

Data source credentials greyed out after domain change

Hello

 

In the Dataset configurations, the following options are appearing greyed out:

- Gateway Connection 

- Data Source Credentials 

- Schedule Refresh 

 

That happened after my org changed my user's domain, from @mycompany.onmicrosoft.com to @mycompany.com.

 

How can we solve this?

5 Replies

  • Hi paulob_involves

     

    What I would suggest doing is make sure that you have got the recovery key for your On-Premise Gateway. This will ensure that when you switch the Gateway over the settings and security will come aross.

     

    Then what I have done in the past is to re-install the On-Premise Gateway which should often ask you if you have a recovery key, which will then bring all your original settings across.

     

    I do hope that this will work due to the domain change, but I am not 100% certain.

    • paulob_involves's avatar
      paulob_involves
      Icon for Advocate I rankAdvocate I

      Hi,

       

      I'm not using any sort of gateway. All my data sources are from web (A Redshift Database, one Sharepoint file, and many web pages - REST GETs).

       

      As far as I have observed, this is the only change, with these options greyed out I cannot check / change data sources credentials, nor change the data refresh schedule. I haven't observed any other problems, I still can publish and share dashboards for example.

       

      We tried changing back my user's domain to the previous one (@mycopany.microsoft.com), doing that these configuration options are not greyed out anymore. Then after switching back my user's domain to our domain (@mycompany.com), it's greyed out again.

      It looks like some bug related to user permissions to change these configurations. 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi paulob_involves,

     

    For troubleshooting, you can check these two items below.

    1. If the dataset is still owned by you when you login with the new domain.

    Data_source_credentials_greyed_out_after_domain_change

    2. Publish a same dataset to the Service with the new domain, then check if you can configure the settings.

    If the issue persist, please create a support ticket here due to the cause could be out of Power BI.

     

    Best Regards,

    Dale

    • paulob_involves's avatar
      paulob_involves
      Icon for Advocate I rankAdvocate I

      I verified, I'm still shown as the owner of the datasets. I tried re-publishing the dataset too, it published ok, but the problem persisted. As far as I observed, the only implication of the domain change is the greying out of these configurations.

       

      I found a (troublesome) workaround by changing back my domain to @mycopany.onmicrosoft.com, and creating a new user with @mycompany.com , then signing up to Power BI and re-publishing everything as this new user, and re-creating all dashboards. It took me half a day, but now it's done. I was still in the process of creating my Power BI web environment, but that can be a big problem for users with more dashboards and consumers.