Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
Hi
We were using on-prem PBI Server and we are migrating to PBI service. We have mulitiple records connecting to MS SQL Server dataset ( MSSQLDS). As we are migrating to PBI service , we want to utilize the shared PBI dataset ( PBIDS ) , as there are lot of reports uses this dataset. The columns are identical between PBIDS and MSSQLDS. Tried adding PBIDS and renaming it to match it to MSSQLDS. Still , the reports does not work . it is looking for MSSQLDS. How do I change the datasource from MS SQL to PBIDS , without recreating reports from scratch?
Thanks in Advance.
Hello @zahirmohideen ,
You could connect the SQLDB with on-premesis gateway https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Thank you for your response. Lot of reports are using the same data source. I can use MS SQL Server with no changes to the report. However , that will not be optimal. I want to use Shared PBI dataset
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
59 | |
30 | |
25 | |
22 | |
21 |
User | Count |
---|---|
57 | |
37 | |
26 | |
24 | |
20 |