New Windows 10 Store Powever BI App and Impersonation Level is Invalid

[BIAM_BAMBOOZLED]

Afternoon everyone. 

Does anyone know how I can over come Impersonation level was not provided, or the provided impersonation level is invalid (0x80070542) 

I am running the new Windows 10 Store Power BI Desktop App with my standard account, the data source is connecting to a SQL DB with an account specified which has read rights on the DB..  Every time I try to connect/refresh I get the error above.

With the new modern app you can't elevate to run with an admin account which was my old way of working. 

Has anyone else experienced this? If so how did you resolve it? 

Any guidance would be greatly appreciated. 

Many thanks

Rich

[v-chuncz-msft]

@BIAM_BAMBOOZLED,

You may check if Resolve issues when connecting to SQL Server helps.

[BIAM_BAMBOOZLED]

Hi Sam

thanks for the info... shame the detail in that article is a little useless now as you can't run the new Modern Power-BI app as an admin.. so I can actually use Power-BI for SQL based queires now..  

Thanks again 

Rich