Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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
    9 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
9 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