My BI reports on app.powerbi.com was working properly for months already and couple days ago I started reciving following message when I try to refresh the data.
I see in Gateway management the connection is successful
I checked some of other silmiar issue and suggested use FQDN and SQL configuration.
But we did not make any change recently.
Please try to add SSL certs in machines. If you have already done that. You can also try to use the Fully Qualified Domain Name in Gateway configuration in Power BI Service and in the Source configuration in Power BI Desktop.
BTW, the on-premises data gateway September update is already available here.
If issue still persists, I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).
Thanks for the reply.
We never had SSL certs in this server, and it just stopped working one day. I checked the query in BI desktop and see FQDN is used.
See the updated and updated it and restarted the gateway service.
Still having the same issue.
I tried to use support ticket but was denial of access as below
I have checked that i'm indeed using a pro user account. Is there some other requirment to submit a support ticket?
If you are a using a pro account, you should be able to open support ticket as above gif with no problem. Based on the message you get, maybe you need to contact with your O365 admin to see if they can grant permission to you.
Thanks for the response.
Can you specifiy what kind of permission they should be looking for?
I meet the same problem. I am a Pro Power BI User, Admin on O365 and i use Admin rights on the Server under the On-premise Gateway and SQL Server!!!
Check it guys!!!