Is anybody else experiencing issues with Power BI service gateway connecting to Analysis Services as of today?
Major issues this morning. All our reports which all use analysis service tabular models (SQL Server 2012) could not be refreshed. They were fine up until 9PM GMT on 30th March. I carried out the following steps to rectify the issue:-
- Removed the on-premise gateway on our UAT server
- Reinstalled the latest gateway on the UAT server
- Created a data source for the required analysis services database which connected successfully in the Power BI Service
- Removed the original report from the Power BI service
- Deployed the report to the Power BI service. The report is using SSAS connection created in step 3
- Checked the report in Power BI service. I received the following error above the report:-
There was a data source error. Please contact the gateway administrator.
I created another data source which was direct query to a SQL Server database, deployed a report for that data source and everything works fine. It is definitely Analysis Services specific. As far as I know nothing has changed on our environments.
Have Microsoft made changes been made to SSAS connections in the Power BI Service? Urgently need this resolved.
Any help would be most appreciated.
Thanks in advance
