cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

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