Forum Discussion

timhopson's avatar
timhopson
Icon for Helper I rankHelper I
6 years ago
Solved

Credentials greyed out - cloud and on premises

Hi, My report uses on premises SQL databases plus cloud sharepoint files.   I have a gateway which maps my two on premises data sources and it shows the cloud data source as optional.   I am una...
Need Help
  • timhopson's avatar
    timhopson
    6 years ago

    Hi GilbertQ , thank you for replying. Yes, I did have that setting ticked. I think I have solved the problem. I had access to two gateways. I noticed that, although I could complete the mapping of the data sources in my desired gateway, the radio button that selected the gateway was never set. I removed the gateway I wasn't using and hey-presto, I was then able to apply my settings.

    regards, Tim.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago

Hi timhopson 


Can you make sure that you have got the following option below enabled on your Gateway options in the Power BI Service. This will allow you to refresh both On-Premise and cloud sources.

 

 

timhopson's avatar
timhopson
Icon for Helper I rankHelper I
6 years ago

Hi GilbertQ , thank you for replying. Yes, I did have that setting ticked. I think I have solved the problem. I had access to two gateways. I noticed that, although I could complete the mapping of the data sources in my desired gateway, the radio button that selected the gateway was never set. I removed the gateway I wasn't using and hey-presto, I was then able to apply my settings.

regards, Tim.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there,

    Thanks for letting us know you found a solution.