Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

monaraya
Employee
‎09-10-2020 10:28 PM

Gateway connection’s toggle button and radio button for choosing Gateway greyed out in Power BI

Issue: Gateway connection’s toggle button and radio button for choosing Gateway greyed out in Power BI Service. Refresh fails with below error.

Error:

Processing error: There is no available gateway.

Cluster URI: WABI-ABC-XYZ-redirect.analysis.windows.net

Activity ID: dxxxxx-d3f1-4969-8a64-yyyyyyyyy

Request ID: 3xxxx-9ea0-5085-29a1-yyyyyyyyyyyyyyyyy

Time: 2020-08-30 15:40:12Z         

Gateway connections greyed out and data sources duplicated:

s1.jpg

Resolution: We used REST API to bind dataset to Gateway since the UI options were greyed out.

Bind the dataset to a Gateway REST API: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/bindtogatewayingroup  

  • Possible cause of the issue is that there could be a glitch in the UI i.e. frontend which did not allow the dataset to be attached to a Gateway - so you saw the options greyed out and refresh failure error message "No available gateway"
  • Since UI was not allowing us to bind dataset to GW, we tried a programmatically approach. We used REST APIs to choose GW or bind dataset to GW and it was successful.

Author: Srishti Sharma

Reviewer: Mounika Narayana Reddy

0