Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DirectQuery from Report Server to remote MSSQL-Server isn't working

Hello Community, i am trying to configure a working DirectQuery from my Report Server to an MSSQL-Server which is not running ob the same server. But i can't figure out how to configure the authenti...
DirectQuery
MSSQL
Report Server
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Anonymous ,

I have seen the same problem before and it is due to Power BI Desktop for RS and Power BI Report Server versions. You can try updating PBRS and Power BI Desktop for RS to the latest version and try again.

 

Similar error refer:

https://community.powerbi.com/t5/Report-Server/PowerBI-RS-May-2019-Desktop-Error-Deploying-to-SSRS-DirectQuery/m-p/733063#M10859 

 

Download url:

https://www.microsoft.com/en-us/download/details.aspx?id=56722 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Lucien (v-luwang-msft),

 

first of all thank you for your reply.

 

I've read many solutions in this community too and tried most of the solutions - exept the upgrade obviously.

Today i made the upgrade of my Report Server to Version May 2022, but the Problem is still the same. I can't run my DirectQuery report and i can see an anonymous login attempt at the MSSQL-Server.

 

I still think there is something wrong with my configuration. Maybe something in the configfiles of my Report Server, maybe something with the SPNs maybe something i didn't find in other solutions or documentations.

 

Unfortunately the upgrade wasn't the solution for my problem.

 

Best regards
Sal_