Showing results for 
Search instead for 
Did you mean: 
debugair Frequent Visitor
Frequent Visitor

Refresh report in import mode as the user viewing the report

Dear all
We are currently setting up an on premise Power BI environment within our company. Most of the data used in the Power BI Reports are in MS SQL Server or SSAS. Our customers use direct query mode or live connection mode to connect to these data sources. We use integrated security by checking the "as the user viewing the report" option on the data source. With the proper constrained delegation settings, all works fine.

Due to the limitations of the direct query mode (single data source only) our users are forced to use the import mode to combine data form different sources. When those reports are published to the server, we do not have the option anymore to configure the data sources to use integrated security (there is no checkbox for “as the user viewing the report”). It seems that the only option is to input windows credentials (username & password) to refresh those type of reports. Since our users do not have a windows password anymore (smartcard) the fun starts.

Is there any way to configure the data sources in import mode to use integrated security (constrained delegation) to access the data sources?

Thx for your support