Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Refresh failed (no available Gateway)

So last week when I first set up my gateway, the refresh worked (and there were places where it prompts me to enter credentials under data source credentials, now it is empty shown in screenshot).  T...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Please install on-premises gateway on your machine and add the Excel data source within gateway following the guide in this similar thread, then choose "Use a data gateway" option under Gateway connection in your first screenshot and check if you can refresh the dataset.

    However, if you still want to use on-premises gateway (personal mode), please delete the dataset in Power BI Service and re-connect to dataset and check if you can refresh it.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Is the machine running your gateway always on?  Is the network it is on always accessable 24/7?

 

I'm wondering if at the time of the refresh that something is closed or powered off.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous Thank you.  The machine is always on and the network is always accessable.

I tried to manually refresh it.  It failed too.

 

Thank you.