Apply button is greyed out when adding a data source to the on-premise data gateway
I noticed when I published a report with an on-premise data source (SAP BW) along with cloud data sources (Sharepoint), the Apply button is greyed out in the gateway connection settings:
Again, this is only applicable to newly published datasets.
For the existing ones, there are no errors, and I can refresh successfully. Like this one, it has actually the same setup, just published in a different workspace some time ago:
I just experienced this yesterday.
Any of you are experiencing it now?
Appreciate the responses!
EDITED--
Check out the comments for the workaround
Microsoft has also posted the issue on the Power BI Support page. Expect the fix to be on 24th of January
21 Comments
- kumar9999Frequent Visitor
Even im facing the same issue from yesterday. One of my source is a sql server and 2nd source is a sharepoint list, when setting up gateway, the apply button is greyed out.
- Gladiator909
Helper I
This is really weird, I have pretty much the same setup and it was working fine until recently.
I think if you remove the "sharepoint" site, the apply button becomes enabled. however, like I said, it was working fine before even with the sharepoint site there....
- AnonymousNot applicable
Hi Anonymous ,
This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform, No:360537118 . Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.
Best regards.
Community Support Team_ Caitlyn - AnonymousNot applicable
Interesting to know there are others who are expieriencing the same issue.
Appreciate the response Caitlyn, looking forward to the resolution - ntdanhFrequent Visitor
same issues here....
- huynhzyNew Member
Same issue here. Looking forward to the resolution.
- AnonymousNot applicable
To anyone experiencing the issue, there is actually a workaround. You need to turn on the Developer Tools of your browser, then select the radio button, and Apply button, then change their properties to 'enabled'
Radio button:
Apply button:
There should be changes, and it might say it still in error, but the refresh/scheduled refresh will work
Again this is just a workaround, just for anyone who needs to fix their refresh issues in the PBI Service asap
As mentioned by v-caitlyn-mstf, this is an acknowledged issue and hopefully they will resolve it soon - alessandrolops9Regular Visitor
I have the same problem. There is a solution?
could the problem be caused by the latest version of the service? - ntdanhFrequent Visitor
Anonymous It works ! I have followed your tip and enable options to make a refresh scheduled !
- OwsikAgataNew Member
same problem