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.
9 Comments
- This would also be useful to set the LocaleIdentifier property to connect to the cube in another language.
JuliänAdvocate I
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- Setting the LocaleIdentifier would be very useful to fully utilize the SSAS tabular cultures
- I don't see why we can't edit connection string properties in general.
- 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.
- On SSRS we could add username to impersonate the logged user while using a static user for the 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)
- 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.
- Status added:Needs Votes
