Forum Discussion

gonzalofvilela's avatar
gonzalofvilela
New Member
4 years ago

Problems connecting data source published as FILE (xlsx)

Hello! I am having problems connecting a data source published as FILE (the files are XLSX) and they are published and configured with the GATEWAY all ok but it does not take me. These files are in ...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi gonzalofvilela ,

 

1. Do you use personal gateway or enterprise gateway?

2. Is your gateway the latest version?

3. What's the status of the cluster?

4. Do you select Allow user's cloud data sources to refresh through this gateway cluster > Apply Under Gateway Cluster Settings?

5. Do you edit the cloud data source credentials Under Dataset settings->Data source credentials?

please select "OAUTH2".

 

 

Try to:

1. Export the data gateway log by selecting Diagnostics and then selecting the Export logs link near the bottom of the page. Reference: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting.

2.Open the Task Manager --> Click the "Services" tab --> Find "On-premise data gateway service" (PBIEgwService")

--> Right click and click "Start" / or "End" to restart.

3. Re-install the latest version of gateway: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-update

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.