Forum Discussion
change datasoruce
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.
Best Regards,
Dale
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.
Best Regards,
Dale
It is highly unlikely that the data in SQL Database will be in the exact same format as it was when you where pulling data from the Access Database. As a result there is a very high likelyhood of changes disrupting the report.
I woudl strongly suggest you go throught the query editor with a fine tooth comb to ensure, it matches 100%
Regards,
Mathew