Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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 @Anonymous ,
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.
@Anonymous , refer if these can help
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk
@Anonymous You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
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 https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.