missing data from visualization

[Anonymous]

I'm having an issue with my data fully populating.  I have 4 csvs loaded from a folder, and the data in the first 3 csvs is populating in my matrix table; however, the last csv is loaded in my table and should be populated in my matrix table as well, but it is not.  I have the calendar table set up using the First/Last dates from the csvs table so I'm not missing it from the date side (I don't believe).  

For futher information, I have the csvs broken up into Quarters, and the first 3 quarter / files (csvs) are loading and working properly, I can't get my 4th quarter / file (csv) to populate in my Matrix table which is a Profit & Loss table to show our Revenue / COGS and EBITDA.  

[Anonymous]

Brilliant!  Thank you!  I'm missing a dimension in my 4th CSV and that's why it's loaded but not being used!  

[Anonymous]

Hi @Anonymous ,

We couldn't get access to your sample link. Please share a sample file by another way. Could you see tables from the 4th csv file in your data model? You can show us a screenshot with your data model. Did you try combine option when you get data?

For reference: Combine data

Best Regards,
Rico Zhou

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

[amitchandak · Accepted solution]

@Anonymous , First of is 4th CSV loaded properly.

Also check if dimensions missing any data link for 4th csv,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.