Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

Data not showing

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?

 

Need Help
Show and Tell

3 Replies

  • stribor45's avatar
    stribor45
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    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\...
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      stribor45
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      #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