cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ksar
New Member

Data gateway

Hello ,

Need Help please

 

 

I have created a data gateway to update my data on a powerbi report connected live to sql server. The Vm in which I installed this gateway doesn't exist anymore and I have no way to change the connection credentials to the new database. I have added new data sources to the gateway but they do not show up in the gateway connection settings. I have created a new gateway with new data sources but I can't select this gateway for the update of the powerbi report in question.

 

6 REPLIES 6
wikkleyn
Super User
Super User

Hi @ksar  I think your issue might be that the database detail differs between what is used in your dataset and what was used to create the gateway connection.

 

Please make sure that the database detail is the same in the dataset and the gateway connection. Only the credentials can differ.

ksar
New Member

And when i add new data sources to the gateway , they do not show up in the gateway connection settings.

Hi @ksar ,

Usually only the gateway administrator can manage the gateway and the gateway's data sources.

If you still want to use the data source of this gateway to configure the refresh, you need to install a new gateway in a new machine to take over the old gateway, and then you can modify the datasource in Power BI Gateway Manage Portal.

For more details, you can read related document: Migrate, restore, or take over an on-premises data gateway | Microsoft Learn , Manage an on-premises data gateway | Microsoft Learn

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

that's what I was talking about in my previous comment when I said "I tried this option too".
As you said , I installed a new gateway in a new machine to take over the old gateway, and i tried to modify the datasource in Power BI Gateway Manage Portal but I still couldn't modify the connection parameters defined before because the boxes are grayed out

ksar
New Member

Hi @v-binbinyu-msft 
I tried this option too, but it still didn't work and I had the same errors and I still couldn't modify the connection parameters defined before.

The boxes (of the server, the database and the authentication information) are grayed out like on the picture below

ksar_0-1666341057867.png

 

v-binbinyu-msft
Community Support
Community Support

Hi @ksar ,

Please try to take over the on-premises data gateway.

vbinbinyumsft_0-1666331278179.png

For more details, you can read related document: Migrate, restore, or take over an on-premises data gateway | Microsoft Learn

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors