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 (8)
RE: Change properties on SSAS OLAP Live connection
Still needed. Same reason as the last comment, but also critical for security in preventing ad hoc connections from sources like Excel. Would like to set CUSTOMDATA.
RE: Change properties on SSAS OLAP Live connection
Is there another way to display diffrent languages in a power bi bases on a SSAS cube ? (in excel we can change the "Extended Properties" to allow users to choose the language of data)
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.