Forum Discussion

daniels13ca's avatar
daniels13ca
Regular Visitor
8 years ago
Solved

change datasoruce

Hello, I have an origin in Access but the data size is very big now, i'm trying to change de datasource to SQL Server and don´t find this option in Power BI Desktop. Is it possible do the migration w...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi daniels13ca,

     

    Seems no direct way available. But we can change the Power Query (M) code directly. One precondition is that the structure should be the same. If they have the same data type, that would be great. 

    1. Usually, the first two rows codes are the data source.

    2. If you have many queries, you have change them one by one. 

    3. Please pay attention to the two parts tagged by blue 1 and 2.

    4. Backup the code first, if you do anything wrong, you can paste the code back and do it again.

     

    If you have any problem doing it, please post the code here. Please mask the private parts first.

    change_datasoruce

     

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi daniels13ca,

 

Seems no direct way available. But we can change the Power Query (M) code directly. One precondition is that the structure should be the same. If they have the same data type, that would be great. 

1. Usually, the first two rows codes are the data source.

2. If you have many queries, you have change them one by one. 

3. Please pay attention to the two parts tagged by blue 1 and 2.

4. Backup the code first, if you do anything wrong, you can paste the code back and do it again.

 

If you have any problem doing it, please post the code here. Please mask the private parts first.

change_datasoruce

 

 

Best Regards,

Dale

daniels13ca's avatar
daniels13ca
Regular Visitor
8 years ago

This is the new code:

 

Thanks:smileyvery-happy: