Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Please can you tell me how to change the data source target from the Excel file to the Access table?
I've seen some threads on changing excel worksheet sources using "Advaned Editor" but I don't see how to change from excel worksheet to access table (my columns in both are in the same order/structure)
Thanks,
CM
Solved! Go to Solution.
Connecting Excel and Access are calling different functions in Power Query. You need to replace the entire Source part in Power Query. And you need to add a step to transform data type for columns when connecting Excel file. You can compare below Power Query for these two sources.
For more details, please refer to: Accessing data functions
Regards,
Connecting Excel and Access are calling different functions in Power Query. You need to replace the entire Source part in Power Query. And you need to add a step to transform data type for columns when connecting Excel file. You can compare below Power Query for these two sources.
For more details, please refer to: Accessing data functions
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |