Forum Discussion

Efy's avatar
Efy
Regular Visitor
8 years ago
Solved

PBI RS Direct Query to SQL server with sql credetials

Hi,   I have installed PBI RS (October 2017) on a machine with MSSQL 2016 for RS database. I am developing a report with PBI desktop for RS  (October 2017) with Direct query mode, the direct query...
  • Efy's avatar
    Efy
    8 years ago

    I have changed the service account to work with NetworkServices, did not help.

    I saw that I configured in the past Execution Account to my user, I changed it back to the default (unchecked "Specify an execution account") and it works now.

     

    Thanks!

Efy's avatar
Efy
Regular Visitor
8 years ago

I have changed the service account to work with NetworkServices, did not help.

I saw that I configured in the past Execution Account to my user, I changed it back to the default (unchecked "Specify an execution account") and it works now.

 

Thanks!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Efy sorry for bothering you back to this.

 

I am in trouble with the same thing you were, but I have never checked the "Specify an execution account" option. I uploaded on RS a report I created with my PBI Desktop using data with Direct Query mode from a SQL Server database, I am able to see it with administrator account but not with any other account.

 

I don't know why.

 

Can you help me?

 

Thanks

 

Nick