cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Data Source Moved to Enterprise Gateway

Hello,

 

I have a dashboard in a Premium Capacity space that I had initially connected to an on-prem data gateway - which I set up under Manage Gateways> Add Data Source> Gateway Cluster to access the on prem datasource.

 

However, we decided later to add the datasource to an Enterprise Level Gateway, in which the settings for this is not maintained in my dashboard. Do I still need to keep the initial on prem gateway that I setup, active? Or can I delete this and my dashboard will still maintain live access to the on prem datasource that has now been added to the enterprise gateway?

 

Please let me know if I need to clarify.

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Data Source Moved to Enterprise Gateway

Hey,

 

you have to be aware of the fact that you do not tie the dashboard to a gateway, instead you tie the underlying dataset to the gateway.

 

I expect that if you setup an on-premises gateway using the "enterprise" mode during installation and define a new data source connection that points to same data source that the current connection will break.

 

But this could be fixed quite easily by pointing the dataset to the data source connection. Maybe the following screenshots give you an idea:

 

Choose the dataset

image.png

  

Choose the new gateway

image.png

 

Hopefully this is what you are looking for.

 

Regards,

Tom

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Frequent Visitor

Re: Data Source Moved to Enterprise Gateway

Hi Tom,

I apologize for being slow to respond to your feedback. My issue "I think" is a little different from the scenario you've mentioned. Just for clarification, yes, I am aware that the underlying data is tied to the gateway and not the dashboard/report(s) itself.

 

Initially when I created the workspace, I created an enterprise gateway on my laptop, and whenever I would shut down my laptop, the scheduled refreshes would not run.

 

We then moved the workspace to Premium Capacity, and the Admins for Premium Capacity said that they would add the (same) datasource to their Enterprise Level Gateway (which is on a server), this was supposed to correct the issue of scheduled refreshes not running when my laptop was offline.

 

However, it seems like this issue still has not been resolved. When I am offline, the data is not being refreshed, whether scheduled or on-demand by report consumers. The refresh keeps turning itself off because it's expecting my laptop to be online... but the refresh should still happen because the datasource is now using the another enterprise level gateway on a server.

 

I don't know if it's not working properly because I still have the intial enterprise gateway that I created active and it's conflicting with the gateway the Premium Capacity team created for the same datasource, because the scheduled refreshes still are not running when I'm offline.

 

My dashboard/report consumers are saying that my data is not capturing their latest updates to the source data, but it should be because the datasource is connected to an enterprise gateway that's on a server. I have attached screenshots to show the schedule refresh issue (it auto-disabled). Hopefully my verbose description of my issue above helps to clarify what I'm trying to resolve.Slide1.PNGSlide2.PNG

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors