Forum Discussion

BridgetTompkin's avatar
BridgetTompkin
Frequent Visitor
4 years ago
Solved

Scheduled Refresh is grayed out

I can do a refresh, but the gateway connection down to scheduled refresh is greyed out What do I need to do?    
Dataflow
Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi,

      If you have access to sharepoint which is sharepoint online (i assume). you can enter the datasource credentials if it ask after take over and schedule the refresh. It will not affect anything. later on if your customer wants to modify something then they can take over and do it.

     

    Thanks

    Hari

  • BridgetTompkin's avatar
    BridgetTompkin
    4 years ago

    Thanks for the help

Anonymous's avatar
Anonymous
Not applicable
3 years ago

The PBI Web must be able to connect to the data source(s) of your dataset. So if you open the Data Source Credentials and it says, 'Failed to test the connection to your data source', it means that one or more of your connections do not have the correct credentials (or any at all).

To resolve:

  1. Edit the connection's credentials
  2. PBI Web will test the connection
  3. Repeat 1-2 for each connection
  4. When all connections are good, the Scheduled Refresh will become available.