cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gooranga1 Senior Member
Senior Member

Data Gateway no longer available to other users

We have been using powerbi for aroud 18 months using the  pro licenses. we have have an on prem data gaetway set up that has been working brilliant for around 18 months.nAll the pbix we use have data loaded and refreshed via the gateway there is no direct query. We have a slightly strange network set up in that our company domain is not a trusted domain with the domain that contains our data but we worked around this and everything was working fine.

 

Around the 22nd August something changed on the web that has impacted the ability to select the data gateway against a dataset once deployed to the web. Now it appears only the user that set the gateway up on our gateway server initially has access to the gateway when setting up new reports or taking over schedules from another user. We used to have 4 logins enabled for this now we only have 1.

 

So now when I goto the dataset of a report to take over the schedule there is no available data gateway, even though I can go view the gateway and modify it and add new data sources.

 

Anyone else experiencing anything similar?

 

All of this has been working fine for 18months it's only the last  3 weeks it has failed lke this. Initially I presumed it was a network change at our end but that has all been checked and is ok. It seems something has changed on power bi. We are currently at a loss as of what to do.

 

workingschedule.PNGNoGateway.PNGGatewaySetup.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
gooranga1 Senior Member
Senior Member

Re: Data Gateway no longer available to other users

Yes we will upgrade our gateway however the issue was that my user had been updated. We have a slightly odd network setup so we have users replicated for 2 untrusted domains but the users are the same on each domain. When mine got out of synch they had to be amended and this somehow generated a new uid for my user I think (I am no network or AD expert as you can probably tell) when this amendment got replicated. Even though my username was exactly the same we had to remove my user from each dataset in the gateway on the web and then re-add it.

 

I can now see the gateway even on the old version of the gateway. 

 

 

4 REPLIES 4
Super User
Super User

Re: Data Gateway no longer available to other users

@gooranga1 Have you updated to the latest gateway? There have been several releases of newer gateways in the last 18 months... This would be the first step.


Near SE WI? Join our PUG Milwaukee Brew City PUG
Ross73312 Super Contributor
Super Contributor

Re: Data Gateway no longer available to other users

I think they dropped support for an older version of Encryption which the older gateways used.  @Seth_C_Bauer is right, you should try to upgrade your gateway as the version you might be using could no longer be supported.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


gooranga1 Senior Member
Senior Member

Re: Data Gateway no longer available to other users

Yes we will upgrade our gateway however the issue was that my user had been updated. We have a slightly odd network setup so we have users replicated for 2 untrusted domains but the users are the same on each domain. When mine got out of synch they had to be amended and this somehow generated a new uid for my user I think (I am no network or AD expert as you can probably tell) when this amendment got replicated. Even though my username was exactly the same we had to remove my user from each dataset in the gateway on the web and then re-add it.

 

I can now see the gateway even on the old version of the gateway. 

 

 

v-yulgu-msft Super Contributor
Super Contributor

Re: Data Gateway no longer available to other users

Hi @gooranga1,

 

Thanks for your sharing. So, you have found the cause and resolved the problem by yourself, right? If so, would you please kindly mark your sharing solution as an answer so that it can benefit more users?

 

Regards,
Yuliana Gu

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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 299 members 3,131 guests
Please welcome our newest community members: