Forum Discussion
zahirmohideen
Helper I
Helper IChanging Data source from MS SQL to Power Bi Dataset without recreating Report
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...
Idrissshatila
Super User
Super UserHello 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 👍
zahirmohideenHelper I
Helper IThank 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