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

Hi,

 

Thanks for your reply,

I should of mention that I gave those permissions, I gave one user high permissions and assigned to him all available roles, no success :(

 

Please help.

 

Thanks,

Efy