Showing results for 
Search instead for 
Did you mean: 
Not applicable

Power BI report server direct query - Impersonate



i have this problem :


Power BI Server on premise May2019


i created a very simple report that show a table from a sql server source.

This report works well just for the only user that have rdp enabled on the server report and that do minium one acces.

In other case i have this error




I not know why tell about SSAS , i 'm not using! just sql server source and all users have permission on it


Some one can help me?




rlbuhtbiadp Frequent Visitor
Frequent Visitor

Re: Power BI report server direct query - Impersonate

We are having the same problem after upgrading to Power BI Report Server May 2019. Power BI creates a tabular model of your data in an embedded SSAS instance when the report is run and should then give the user read access to this model.


In the May update, this permissions assigning process doesn't seem to be working which is why your error message says that you can't connect to the SSAS server. We've also seen that the default mode of the model is changed to 'Import' instead of 'DirectQuery' when we query the SSAS instance from the report server. 


Our workaround is to re-install the January version of PBIRS desktop which seems to work OK even with May's version on the server. Hopefully MS can issue a fix so we can use the new May features again soon.

Helpful resources

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 84 members 1,385 guests
Please welcome our newest community members: