exporting data to sql server table: the given columnmapping does not match up with any column in the source or destination.

[hamedelbhrawy]

exporting data to sql server table: the given columnmapping does not match up with any column in the source or destination.

[hamedelbhrawy]

i load all Tabels from bi Dataset except on table its rows more than 14 million i get this error when export data to SQL server :
exporting data to sql server table: the given columnmapping does not match up with any column in the source or destination.

[dgosbell]

What version of DAX Studio are you using?
Are you exporting to a new or existing table?
Does it work if you let the export wizard create the table?

[hamedelbhrawy]

Version 3.0.7 (2023-04-18)
export to new table
no it doesn't

[hamedelbhrawy]

i think this column name "[HH:MM:SS (AM/PM)] " case the problem put i can't edit it because i don't have data source any reconditions

[dgosbell]

I just tried that column name and it worked fine without the square brackets and with them it throws an error trying to create the table. I should be able to fix the error creating the table where the column name starts and ends with square brackets, but I still cannot reproduce the column mapping error. Are you able to share a list of the column names or a .bim or .vpax file?

[hamedelbhrawy]

Coulmns name.csv

you will find columns name here if there any other thing i could help with just ask me to do .

thanks for your effort

[hamedelbhrawy]

kindly could you explain what should i do make update or how i could use your code ?

[dgosbell]

I think I have a fix in place for this now. If you are interested in testing a preview build you can download one here https://ci.appveyor.com/project/DarrenGosbell/daxstudio/builds/47231146/artifacts otherwise this fix will be in the next release.

[hamedelbhrawy]

I think I have a fix in place for this now. If you are interested in testing a preview build you can download one here https://ci.appveyor.com/project/DarrenGosbell/daxstudio/builds/47231146/artifacts otherwise this fix will be in the next release.

Thank you for your invaluable assistance

[hamedelbhrawy]

i hope if i could export certain query to sql too .