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


Helpful resources

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 265 members 3,021 guests
Please welcome our newest community members: