Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Paul77
New Member

Data Source in Power BI Report Server

Do I understand correctly that the data sources created in the "Power BI Report Server" are available only in the "Report Builder"?

Thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, @Paul77 

You're referring to a shared data source hosted in the Power BI Report Server web portal:

vjianpengmsft_0-1740380824903.png

This data source, we can use it in Report builder:

vjianpengmsft_1-1740380881485.png

vjianpengmsft_2-1740381008441.png

Or you can use another SSDT tool to connect to this shared data source. 

Manage Report Data Sources - SQL Server Reporting Services (SSRS) | Microsoft Learn

vjianpengmsft_3-1740381108487.png

 

 

Best Regards

Jianpeng Li

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

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi, @Paul77 

You're referring to a shared data source hosted in the Power BI Report Server web portal:

vjianpengmsft_0-1740380824903.png

This data source, we can use it in Report builder:

vjianpengmsft_1-1740380881485.png

vjianpengmsft_2-1740381008441.png

Or you can use another SSDT tool to connect to this shared data source. 

Manage Report Data Sources - SQL Server Reporting Services (SSRS) | Microsoft Learn

vjianpengmsft_3-1740381108487.png

 

 

Best Regards

Jianpeng Li

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

 

nilendraFabric
Community Champion
Community Champion

Hello @Paul77 


No, data sources in Power BI Report Server are not exclusive to Report Builder.
• Paginated reports (`.rdl`) can use shared data sources across reports via Report Builder.
• Power BI reports (`.pbix`) rely on embedded data sources but can reuse published datasets as a workaround

 

 

Data sources in Power BI Report Server operate differently depending on the report type and tool used.

 

Created and managed within Power BI Desktop (optimized for Report Server). These data sources are embedded directly into the `.pbix` file and must support scheduled refresh

Created in Power BI Report Builder or SQL Server Data Tools (SSDT). These can be configured as shared data sources on the Report Server, allowing reuse across multiple paginated reports

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.