Forum Discussion

MaxMuster's avatar
MaxMuster
Frequent Visitor
4 years ago
Solved

PBI Report - Windows Authentication "As User Viewing the report" Import mode

Is it possible to configure PBI Reports with "Import Mode" Datasource to use windows authentication "as the user viewing the report"?   I know it's possible with Direct Query Reports but with Impor...
credentials
import
integrated
PBI
power bi
  • AdEzone's avatar
    AdEzone
    4 years ago

    Ok, let me explain something:

     

    1.- The image you posted before when connecting to SQL Analisys Services is always "live connection" never imports the data. In this case you have to configure the permissions on the Analisys Sevices model Security tab. 

     

    2.- When your report is used in "import mode" connected to a SQL Database or Excel file or any source that can be used in import mode and the user is not a server (or specific folder) administrator, no other user can see the credentials you are writting down on the scheduled refresh tab. Then there is no risk that anyone can see them. On top of that, if you have created an specific user in the domain with read-only privileges on the database, I see no point so avoin entering user-password on the report refresh.

     

     

    In other words, when you have an import-mode connection and you want scheduled refreshes you NEED to introduce credentials for this....

     

    Regards,

     

AdEzone's avatar
AdEzone
Frequent Visitor
4 years ago
Hi,
It is not possible to refresh without the credentials. 
 
The server needs to connect to the db. 
 
Maybe you can create a windows account for this purpose and provide read only credentials to the specific database you need, not all db engine, and use this account in the RServer…..
Regards
  • MaxMuster's avatar
    MaxMuster
    Frequent Visitor
    4 years ago

    So something like this is not possible in import mode even when the users have access to the database?

    https://community.powerbi.com/t5/image/serverpage/image-id/44385iCB22F849ED33A968/

    Well I can see why it would be a problem with scheduled refreshs but would be nice if the user viewing the report would have some possibility to refresh the data without adding the credentials.

    Cause I try to upload the report and trigger the refresh programmatically (which would work with stored credentials) on pbi report servers from multiple customers.