Data not trasnferring to Power Pivot

[gjb]

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 below. What is going wrong?

Power Query:

Power Pivot view:

[Anonymous]

Hi @gjb ,

Did you check the data type of the date column in Power Pivot view?

And make sure click "Close&Apply" button or click "Apply" button to apply the data to the frontend.

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]

Hi Stephen,

Yes, the data type of the date column in Power Pivot is "Date" and the data type of the Last Gift Amount and Lifetime Gift Totals columns is "Decimal Number."

I'm not seeing a "Close&Apply" or "Apply" button. I've chosen Close and Load.

Thanks

[Anonymous · Accepted solution]

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]

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.