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

All Data Sources Mapped, No Available Gateway Error

All of my data sources have an appropiate path in the gateway, they find a match in the Maps To dropdown.

Status is Green Check mark running.


Use a data gateway toggle, apply changes button, schedule refresh are all greyed out.

Error message says no available gateway.


This dataset is too large to publish after loaded in. I save it as a template to empty the tables, convert it back to a PBIX and cancel the load. I have succesfully done this before. This time it won't refresh.

Frequent Visitor

I'm still not sure what exactly the issue is, but all it took to resolve was someone else taking over the dataset, they mapped the exact same sources, and they could refresh using the gateway.


I'm not sure if signing out and back in would have fixed it for me, but it seemed like a web/service issue and not something with my gateways or pbix.


Thanks for the links

Hi @GReeves11 ,


So strange.
Try to log in to the local gateway client to check whether the gateway status is normal.



Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Super User
Super User
Super User
Super User

@GReeves11 You could check the Issues forum here:

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to Scroll down and click "CREATE SUPPORT TICKET".

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Super User
Super User

Hi there

I think that you might need some data in your tables?

Not sure what has changed, but I always have had the full dataset when uploading the reports.

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

Proud to be a Super User!

Power BI Blog

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!