Issue with displaying new data in the table in the report field

[ekramulmostaqui]

Hi,
I have two data tables that are located in two excel files. I merged two data tables and did some formulas. Then I created a table in the report field based on the merged table. The data are displayed perfectly in the table. But recently, excel files are updated with new data. I can see that the data are updated in the merged table. But when I tried to display the new data in the table in the report field, the new data could not be displayed. I tried to work with filter. In filter area, I did not see the new data.

What could be the reason?

Note that The datatable contains data more than 180000. And every month almost 30000 data will be added to the data table.

[Idrissshatila · Accepted solution]

@ekramulmostaqui , can you click on this icon and show me what it's showing 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[ekramulmostaqui]

I clicked on the filter option. The following information was displayed. There are 6 process names. In the new data I have one more process. That means there should be 7 processes.

In the image above, I see that the date filter is used twice. In my case it should be between 01.01.2023 and 01.10.2023. 

[Idrissshatila]

@ekramulmostaqui , can you clear all these filters from the report and check if the data shows up.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[ekramulmostaqui]

I have cleared the filter and also deleted the slicer. Still I can see the below date filter which I did not use anywhere.

[Idrissshatila]

@ekramulmostaqui ,

check if its coming from another visual or from the filter pane.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[ekramulmostaqui · Accepted solution]

I have created a new sheet and a new table. It works perfectly. I think it is a problem of Power Bi or it could be for the dynamic calendar. I used the minimum and maximum dates based on the table data to create a calendar. Initially, I had data up to 31.07.2023, so the date of the calendar is between 01.01.2023 and 31.07.2023. After I loaded new data, the calendar was changed up to 30.09.2023. Therefore two date filters were created.

[Idrissshatila]

@ekramulmostaqui , so the issue was the date filter.

if the issue is resolved, mark a comment as a solution to close the thread.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[ekramulmostaqui]

Hi @Idrissshatila,

In the filter area, i have selected some values. After adding new data, I tried to select the new data from the filter area. I do not see in the filter area.

To check any other filter in the report preventing the new data to show, I have created demo table. Unfortunately, new data are not available for the demo table also. 

I have an overview sheet in the report. And some individual sheets for all the selected data. The strange thing is that the problem only occurs for the table of the overview sheet. For the new sheet of new data, there is no problem.

[Idrissshatila · Accepted solution]

@ekramulmostaqui , can you click on this icon and show me what it's showing 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Idrissshatila]

@ekramulmostaqui ,

it should be displayed, are you sure that there is no data filter or any other filter in the report preventing the new data to show?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡