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,
Hi.
Thanks for your anwser. Bad news are:
- I cannot use LiveConnect because I have some Excel and SQL Server data sources in my report, hence standard mode will not work
- I read in some post here that I can use personal gateway for this purpose! But seems I cannot use this also!
- Our company won't give me admin rights, neither will help me configuring Power BI service!
So, I'm working on another solution: Using SSIS to bring data to SQL Server and use it as data source. But I have stuck there too (This post on stackoverflow).
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.