Forum Discussion

pdeville's avatar
pdeville
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Effective user name on SSAS direct query datasources in PBIRS

I am testing SSAS direct query data sources in PBIRS and it appear it does not use effective user name. Is this the expected behaviour? This coulds be an issue for my client, when the users don't u...
Direct Query
effective user name
Report Server
SSAS
  • pdeville's avatar
    pdeville
    8 years ago

    As a workaround, on SSAS data sources, we can specify a windows account for the connection and force the "log on as the connected user" to apply an effective user name on the SSAS connection and apply the role based access rights defined in SSAS cubes.

    This only work for SSAS data sources. To my knowledge, there is no workaround for SQL DB and other data sources.

inayatkhan's avatar
inayatkhan
Frequent Visitor
8 years ago

Thank you "pdeville". However this appears a different connection type to the the Gateway Clusters and the Analysis services connection set up on the Power BI Service.This is shown below. Could you elaborate on the connection type that you showed?

pdeville's avatar
pdeville
Icon for Advocate I rankAdvocate I
8 years ago

This topic is about Power BI Report Server (or PBIRS), the on-premise version of Power BI, not the cloud version.

Theses are two differents products

 

Since it is a on-premise solution, PBIRS does not use the data gateway.