Forum Discussion

ChristofferL's avatar
ChristofferL
Frequent Visitor
8 years ago
Solved

Rows missing in imported data from SQL-Connection (Power BI desktop)

Hi,   When I import data from an SQL connection to the Data-model in Power BI Desktop the Data actually loaded to Power BI does not match data in my Query Editor Preview. It seems like some rows ar...
Need Help
  • ChristofferL's avatar
    ChristofferL
    8 years ago

    Hi thank you for the tip.

     

    I managed to solve the issue and it indeed had to do with the column formating. The data format for the matching columns in the query merge were data type 'Any' for both columns.

     

    For some reason most rows matched except a few rows apparently having a different format. I changed the format of the matching ID columns to 'Text' which solved the issue.

     

    Thanks for your help.

     

    Regards

    Christoffer

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi ChristofferL,

 

In my opinion, I'd like to suggest you to deal with this column to remove any whitespace or other special characters.

In addition, you can also try to modify the filter mode to 'contain' or 'starts with'.

 

Regards,

Xiaoxin Sheng

ChristofferL's avatar
ChristofferL
Frequent Visitor
8 years ago

Hi thank you for the tip.

 

I managed to solve the issue and it indeed had to do with the column formating. The data format for the matching columns in the query merge were data type 'Any' for both columns.

 

For some reason most rows matched except a few rows apparently having a different format. I changed the format of the matching ID columns to 'Text' which solved the issue.

 

Thanks for your help.

 

Regards

Christoffer