Missing Data from Excel Import

[scottybank217]

I am having an issue where data from my Excel file is visible in the Power Query editor but it won't display properly in my report. I have data separated by type for each month-year for the last 15 years. All of the data is structured the exact same, but my report will not pull in data for the month of November 2011.

I don't have any filters in place that would restrict this month. I have attached a couple of photos showing the data in the power query editor but it not showing up on my line graph.

Any help would be appreciated.

[v-lili6-msft]

hi

Click 'Refresh' botton in power bi desktop to have a test.

Just from the screenshots we coouldn't find the problem.

if possible, could you please share your sample pbix file and datasource excel file for us have a test, that will be a great help.

Regards,

Lin

[scottybank217]

Hi Lin,

I had already tried to do that but that didn't work. I have tried some other work arounds from previous ideas posted here but nothing seemed to work.

Can you advise on how to share my pbix and xlsx files that I am using?

[v-lili6-msft]

hi

take a look this:

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Regards,

Lin