Forum Discussion
Accessing Power BI Reporting Services Data Sources in Power BI reports
DEMCOLO wrote:I have created data sources on the PowerBI reporting server to on prem sql servers similar to the data sources that we have on our SQL Server Reporting server. Should those users with the PowerBI Pro licenses be able to access these data sources through the PowerBI desktop that they downloaded from the reporting server (current Version: 2.129.2203.0 64-bit (May 2024))?
No, those connections are only available to paginated reports.
Hi, d_gosbell ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello, DEMCOLO . I am glad to help you.
I agree with d_gosbell's suggestion. This is my test:
I create a data source in Power BI Report Server.
Unfortunately, Power BI Desktop does not support the use of data sources in Power BI Report Server.
Instead, Report Builder can be used.
In Power BI Desktop/Power BI Desktop(RS version)
In Microsoft Report Builder
(could be used)
Because these data sources are designed for paginated reports (PBIRS), Power BI Desktop cannot use them directly to create interactive reports.Power BI Desktop needs to connect directly to the data sources, which ensures data access independence and flexibility.
The direct link to Power BI desktop(RS)/Power BI desktop should be Power BI Service.
I hope you find the following links helpful
URL:
Solved: Using Data Sources in PowerBI Report Server (Augus... - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian