Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Change properties on SSAS OLAP Live connection

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