Forum Discussion

gjb's avatar
gjb
Regular Visitor
3 years ago
Solved

Data not trasnferring to Power Pivot

I loaded a table into PowerQuery and it loads correctly--first image below. When I connect and load it to the Data Model, the currency all appears as "0" and the date fields are blank--second image b...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi gjb ,

     

    This issue can occur when the data types of the columns in the source table are not recognized correctly by Power Query. You can try to change the data types of the columns in Power Query Editor before loading the data to the Data Model. You can change the type of the column to date and number in Power Query, and if that doesn't work, try the text again.

    Also have you tried to click buttons below to see if the filters contain data other than blanks and 0s?

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi gjb ,

 

This issue can occur when the data types of the columns in the source table are not recognized correctly by Power Query. You can try to change the data types of the columns in Power Query Editor before loading the data to the Data Model. You can change the type of the column to date and number in Power Query, and if that doesn't work, try the text again.

Also have you tried to click buttons below to see if the filters contain data other than blanks and 0s?

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

gjb's avatar
gjb
Regular Visitor
3 years ago

Hi Stephen,

 

I figured out that the issue was blanks, 0's, and nulls. I cleaned up the data and it then populated into Power Pivot. Thanks for your help.