Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Ironpixel
Employee
Employee

Changing from Personal to Data Gateway failing

Hello,

I am trying to schedule an autorefresh for my data and in trying to change the default gateway from a personal(no longer installed) to a data gateway(installed on a server) it keeps failing.

 

Any ideas on how to resolve this?

Error pasted below.

 

I have tried reinstalling the personal to have it available to change away from and that hasn't worked.

Thanks

=============

Something went wrong.
 
Failed to use the selected gateway. Please make sure the gateway is up and running and try again.
Please try again later or contact support. If you contact support, please provide these details.
Activity IDe6251c59-f386-4e16-955d-5b2399f9fde3
Request ID7cfce85a-f6d8-196d-708e-b92ebad9fc0e
Correlation ID5e139881-8541-4daf-cc06-1bacc6e1612c
Status code400
TimeThu Sep 29 2016 11:10:46 GMT-0700 (Pacific Daylight Time)
Version13.0.1700.320

=================

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@Ironpixel In my experience what you should do is get rid of any instances of gateway. Delete registry keys and folder and files from previous installation and then install data gateway.

View solution in original post

4 REPLIES 4
v-qiuyu-msft
Community Support
Community Support

Hi @Ironpixel,

 

Based on my test, both personal gateway and on-premise data gateway are installed on the same server previously, and the dataset is set to use the personal gateway. After I uninstall the personal gateway, back to the dataset settings, I'm also able to select the data gateway and click Apply button.

 

In your scenario, I would suggest you check if you have created a data source under data gateway which use the same connection string as one in Power BI Desktop. You can refer to dparkinson's last reply in this similar thread: Enterprise Gateway - Something Went Wrong. Failed to use the selected gateway.

 

In addition, does the dataset contains one or more data sources? Data gateway is not supported in some scenarios like one dataset contains data sources connect to SharePoint Online and SQL Server.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ankitpatira
Community Champion
Community Champion

@Ironpixel In my experience what you should do is get rid of any instances of gateway. Delete registry keys and folder and files from previous installation and then install data gateway.

Greg_Deckler
Super User
Super User

I've seen multiple people have these kinds of problems when trying to swap out the gateway. You can try sending a frowny face to support from the Service.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

The smily face only gives an option to give a rating for PowerBI all up, so this doesn't seem to be an option.

 

Hoping for a solution.

Thanks!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors