Forum Discussion

johnyip's avatar
johnyip
Icon for Solution Sage rankSolution Sage
3 years ago
Solved

Error occurred in appending a SQL table with an excel file

I tried to append (or in SQL language, union) two data sources, one of them is from Azure database and another is simply an Excel file.   Everything works fine when I was preparing the steps in Pow...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • johnyip's avatar
    johnyip
    3 years ago

    Hi all,

    I found the cause. That is because of some human errors in the data preparation steps I have made for the Excel data source.

     

    I made one silly mistake by defining "YYYYMM" in the Excel source, while the original table's column is "YYYY MMM". I just changed the Excel source's custom column from showing "YYYYMM" to "YYYY MMM", and then everything works.

    So, I think this error can be caused by data format inconsistency, when you have used FIND() in DAX (specifically, you can search for " " in "2022 Jan", but not in "202201". This is what I observed.).

     

    Hope anyone who encountered the same problem and read this post can be assisted.

johnyip's avatar
johnyip
Icon for Solution Sage rankSolution Sage
3 years ago

Hi all,

I found the cause. That is because of some human errors in the data preparation steps I have made for the Excel data source.

 

I made one silly mistake by defining "YYYYMM" in the Excel source, while the original table's column is "YYYY MMM". I just changed the Excel source's custom column from showing "YYYYMM" to "YYYY MMM", and then everything works.

So, I think this error can be caused by data format inconsistency, when you have used FIND() in DAX (specifically, you can search for " " in "2022 Jan", but not in "202201". This is what I observed.).

 

Hope anyone who encountered the same problem and read this post can be assisted.