Forum Discussion

NickGMead's avatar
NickGMead
New Member
3 years ago
Solved

Deploying a Report to Local PBIRS with a DirectQuery to Another Local SQL Server - Help :)

Hello!   Apologies if this is a silly fundamentals question around something I've overlooked,   I've created a report in a PBI Desktop which relies on a direct query to a local sql instance (On a...
Data Source
Direct Query
PBIRS
Report Server
  • NickGMead's avatar
    NickGMead
    3 years ago

    Thanks for the response Henry,

     

    I was just coming back myself to mention I had managed to fix this, As a new report server user I expected setting the permissions on the data source in PBI Desktop would carry over to the RS, And whilst the connection string did, the permissions recorded the very first credentials i had used in Desktop and don't update in subsequent saves of the report.

     

    Fixed by going to the report server, Selecting the elipse menu on the individual report and going to "Manage". In there i could specify the user credentials for the sql user which in turn allowed the report to query the local sql server and work 👍

     

    Cheers!

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
3 years ago

Hi NickGMead ,

 

According to your description, the sql data source connected through dq mode in powerbi report server has restrictions in terms of permission validation.


You can check the following related documentation links:

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.