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

Dataset stops working on publish with gateway error

It seems like this only happens to some people but I'm not sure what the pattern is.  When they publish a new version of a report from Power BI Desktop the report stops working.  A pink error message shows at the top saying "There is no gateway to access the data source XYZ."  XYZ in this case is an SSAS cube accessible via on-premise gateway.  I can't change the settings without taking over the dataset.  As soon as I take over the dataset the report starts working.  Is the issue related to the permissions of the person publishing the report?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hi there

Have you enabled the User mapping under the Data Source settings in the Gateway?




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

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
Super User III
Super User III

Hi there

Have you enabled the User mapping under the Data Source settings in the Gateway?




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

Proud to be a Super User!







Power BI Blog

View solution in original post

Community Support
Community Support

Hi @albran ,

 

Currently, only the owner of the report can Schedule a refresh or run a manual refresh using the Refresh Now from the Dataset menu.

If other users need to run a refresh, they will need to take ownership of the Dataset using the Take Over button on the Scheduled Refresh screen.

Settings-for-Demo-Report.gif

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors