on 29 May 2017 15:25:31
For Power BI Desktop app and SSAS OLAP Live connection I would like to be able to have access to/change properties on the connection string.
One common need that I have is to change the effectiveusername property in order to run my reports as one my end user when troubleshooting.
- Comments (6)
RE: Change properties on SSAS OLAP Live connection
On SSRS we could add username to impersonate the logged user while using a static user for the connection.
RE: Change properties on SSAS OLAP Live connection
This also would be useful for setting the Role for security testing. Interesting that from SSDT, I can use the Analyze in Excel button and create a live connection to the model with EffectiveUsername or Role, but Power BI Desktop does not allow this. Power BI even has a View as Roles button that could easily change the connection string but is unavailable for SSAS live connections.
RE: Change properties on SSAS OLAP Live connection
I don't see why we can't edit connection string properties in general.
RE: Change properties on SSAS OLAP Live connection
Setting the LocaleIdentifier would be very useful to fully utilize the SSAS tabular cultures
RE: Change properties on SSAS OLAP Live connection
After establishing a connection with SSAS you cannot see with which SSAS-Instance (PROD,DEV,TEST) your colleague is connected, just with unzipping the .pbix
RE: Change properties on SSAS OLAP Live connection
This would also be useful to set the LocaleIdentifier property to connect to the cube in another language.