Forum Discussion
Modifiy dataset connected to gateway
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?
2 Replies
- amitchandak
Super User
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 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.
