Forum Discussion
Using personal gateway with SSAS
I know this is not a solution, but may help others facing this issue. I finally managed to solve my problem using a SSIS package with OLE DB data source and MDX queries to bring data to local SQL Server and connecting report to it. At least it works and my report can be refreshed in Power BI service.
Hi. The docs says that you cannot use a Personal Gateway to connect SSAS. The live connecto to SSAS is only for standard.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
You should talk with your company to help them understand the requirements to setup a gateway. If they won't give you admin permissions maybe the would configure themselves with your guide or something like that.
I hope that helps,
I know this is not a solution, but may help others facing this issue. I finally managed to solve my problem using a SSIS package with OLE DB data source and MDX queries to bring data to local SQL Server and connecting report to it. At least it works and my report can be refreshed in Power BI service.