Hi, In Power Query, the Map Tables screen looks exactly like the one shown in the training materials, but the column mapping behaves differently. Specifically: The Auto Map button is located at the bottom of the screen instead of where it’s shown in the training. After manually mapping the "Name" column and pressing the Publish button, the Excel file fails to upload. It seems the issue might be related to the data type of the "Contract Amount" column. Can you advise on how to resolve this and successfully upload the file? Thank you!

Issue with Column Mapping and File Upload in Power Query

Merav Hacohen 0

Hi,

In Power Query, the Map Tables screen looks exactly like the one shown in the training materials, but the column mapping behaves differently. Specifically:

The Auto Map button is located at the bottom of the screen instead of where it’s shown in the training.
After manually mapping the "Name" column and pressing the Publish button, the Excel file fails to upload.

It seems the issue might be related to the data type of the "Contract Amount" column.

Can you advise on how to resolve this and successfully upload the file?

Thank you!

Syed Saleem Peera 9,620 Reputation points Microsoft Vendor

2024-12-02T02:51:05.0666667+00:00

Hi Merav Hacohen,

Thank you for reaching out to us on Microsoft Q&A forum.

Can you please specify the exact Learn Path/Module name/Exercise link where you are encountering this error?
Syed Saleem Peera 9,620 Reputation points Microsoft Vendor

2024-12-03T03:59:02.91+00:00

Hello Merav Hacohen,

Thank you for reaching out on the Microsoft Q&A forum.

Can you please specify the exact Learn Path/Module name/Exercise link where you are encountering this error along with the screenshot for reference.

Share via

Issue with Column Mapping and File Upload in Power Query

Your answer