Forum Discussion
Resolver IReport Design with PBI Desktop: best practice to access Analysis Services cubes via gateway
I would like to sum up this thread and also add some words about the behaviour in Excel.
If you use Analyze in Excel, it works similar to accessing a dataset from Power BI Desktop. It is more transparent what happens, because you can have a look at the connection properties in the Excel file that is generated by "Analyze in Excel".
The screenshot shows that the connection is based on the gateway configuration.
So again there is the assumption that a client can use the same connection to acess the server that is used by the gateway.I would call this at least a "design gap" that it is not possible to add an https-endpoint to the configuration that is used by clients to access an on premises server.
In respect to Excel online I would call it even a "design flaw", because the local adress definitely can't work. The gateway would be needed!Summary for connecting to SSAS on prem through the dataset in Power BI service.:
Power BI Desktop: works, if the client has access to the SSAS box directly (and OLE-DB driver installed)
Excel Desktop: works, if the client has access to the SSAS box directly (and OLE-DB driver installed)
Excel Online: doesn't work
Super User
No matter which mode you use it will have to connect from the Power BI Service via the Gateway to connect to your On-Premise SSAS Server.
I have used question 1 (in your example) for years without any issues and works very well.
Resolver IHi Gilbert,
thank you for your answers. However, I find that it is not so easy.
I did more analysis, and as I already guessed, the data connection does not through the cloud, even if I use the dataset. PBI Desktop just asks fetches the metadata and tries to connect to the SSAS server directly.
In our company, it is not allowed to access the database server with SSAS directly. We are using the HTTPS endpoint.
I don't see a way to change the server address if I connect to the dataset.
I agree, if the connection as dataset works, it is the better option.
I'm afraid we need to take the other route with its publishing-difficulties.
Regards
Michael
- GilbertQ
Yeah you are correct that it would have to go via the gateway directly to the SSAS Server. As far as I know currently there is no other way to connect.