Today I could not edit any dataflows for a client and was constantly getting “… prod.powerquery.microsoft.com refused to connect”:
Twitterverse to the rescue
After a couple of unsuccessful trials I went to the twitterverse to ask around if anyone else was experiencing the same (thinking that there was an issue with the service in general). Thankfully Dan Szepesi had the fix to my problem, which was actually a bug. His solution was to replace the “www”-part of the URL by “app”. This is his description:
When browsing powerbi.com and trying to edit workflows, if the URL in your browser (host header) is powerbi.com, you will get an error when editing dataflows. This will fail in IE, Edge, Chrome and FireFox.
I was prompted to sign in again, but then I was finally able to edit my customer’s dataflow. Big thanks to Dan and the Power BI community on Twitter for that!
Dan also provided some additional information about this bug, that I’m posting here as it is (it is well above my head 😉 ):
In the response headers to this GET is the following:
Breaking out the Frame-Ancestors part: frame-ancestors ‘self’ adf.azure.com
Hope you found this post soon enough.
Enjoy and stay queryious 😉