Modifiy dataset connected to gateway

[Anonymous]

Scenario:

We have a premium capacity workspace where we have an enterprise gateway setup. There is a dataset that pulls data using that gateway. I have the pbix file with the dataset and I want to modify it in power bi desktop and republish it to the workspace, but I encounter a DSN error message when I try to transform any of the data.

I'm assuming it cannot connect to the enterprise gateway through the desktop application. What can I do to be able to modify this dataset?

[Anonymous]

Hi @Anonymous ,

Please Ensure the data source name and driver are specified correctly.

You would also need to add all the CSV data sources under registered on-premises gateway. Then you would be able to use on-premises gateway to refresh your dataset.

If I am misunderstand your meaning correctly, Please contact me and tell me more details.

Best Regards

Community Support Team _ polly

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

[amitchandak]

@Anonymous , Is gateway up and running. and it signed in.

Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk