Data not showing

[stribor45]

I have an Excel sheet that I use as a source. I add more data to it at the beginning of each month.  I encountered a problem where I didn't see the new data (Data from Feb 1, 2024)  I added to my visuals.

This is what I did:

1. Added the data to my sheet which is sitting on my OneDrive
2. I refreshed all in the power query editor  inside the PBIX file and confirmed that data for February is there
3. I hit close and applied and I also refreshed the report as well in the pop-up screen I can see a list of all tables currently refreshing but not the table whose source is my Excel file
4. After #3 has been completed I also confirmed in the table view that the data for February is there yet when I adjust the slicer for February nothing is shown.  All other visuals that use different tables show February data

I tried adding new visuals with fields I used in problematic visuals and data is not showing for February

Any suggestions?

[Anonymous]

Hi @stribor45 ,

Based on your description, here are a couple of steps that can help us move forward in resolving the issue:

1.Verify Data Model and Relationships:

Check if the table relationships are correctly set up in your Power BI data model. This is crucial because if the relationships are not properly defined, the filter context from the slicer will not propagate as expected, and your visuals will not reflect the new data.

2.Slicer Configuration:

Inspect the slicer configuration to ensure it's not filtering out the new data unintentionally. Check if the slicer is set to 'Select All' or if there are any selections that might exclude the new data points. It's also important to verify that the slicer is connected to the correct field which is updated with the February data.

3.Have you checked if there are any filters applied on the report level or on specific visuals that might be excluding the new data?

Best Regards,

Neeko Tang

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

[stribor45]

#1 - Yes because all other data is in the same file (before Feb) and it is showing fine when the slicer is adjusted. Relationship in model view is set correctly

#2 - Slicer is set as "between" type and selection is made as Feb 1 - Feb 8 nothing shows but when you change the slicer to anything before Feb 1 data is shown.

#3 - Yes I did no fliters are applied to this visual

Also if same file is referenced in different away as described above everything works correctly

[stribor45]

the only way I was able to get it working when I changed the reference to me file from 

Source = Excel.Workbook(Web.Contents("https.....

to

 Source = Excel.Workbook(File.Contents("C:\Users\...