Datasource not showing newly added rows when refreshed

[TameshDoobay]

Hi,

I'm using an Excel Table as my datasource. It was working well for a while. I would add more columns to the table in excel, save and quit, refresh in BI, and it woud load fine.

Then, I added more rows in the excel table, saved and quit, then refreshed in BI. It refreshes successfully but doesn't load the new rows. I've refreshed several times and refreshed in the PowerQuery editor too. I've ensured that the data entered is a part of the table. I've seen no errors.

I uploaded the same table again (now I have two of the same table uploaded in BI), and it loaded all of the rows. I added another row in excel, saved and quit, refreshed the duplicated in BI, and the row loaded in.

I could simple use the new, duplicated upload of the table. But all of my measures and calculated columns are in the original table upload.

Any suggestions on how to fix this?

[TameshDoobay]

I've tried a few things:

1. Removed all calculated columns and measures from original table.
2. Created a reference table, added all of the calculated columns and measures to the reference table.
3. Tried to refresh original table with no calculated columns and measures.
4. Refreshed with no errors but did not update data.

I also tried this:

1. Added new table
2. added a few rows and data into data source, saved and quit
3. refreshed datasource in power BI
4. new rows show up.
5. Create reference table, add calculated columns and measures to reference table
6. Add/remove rows from datasource
7. Saved and quit
8. refresh in powerBI
9. No updated data.

From this behaviour, it seems that once the original table that's uploaded is "Tainted" by calculated columns and measures, it no longer wants to update data from data sources when clicking refresh.

No error messages, no popups, nothing.

FYI, using excel file locally on my laptop as data source.

[Anonymous · Accepted solution]

Hi, @TameshDoobay 

Based on the steps you mentioned, I tried to add new rows in Excel when refreshing when I didn't create calculated columns and measures. When I refresh after creating a measure and calculated column, it still works fine.

Ctrl+T to create table in Excel. The table before change:

After adding rows and columns in Excel:

Under my tests, the refresh function is fine. Maybe you can update your Power BI Desktop, or try reinstalling it. You can also look at how my operation differs from yours, and maybe that's the crux of the matter.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[TameshDoobay]

Update,

I did some more testing.

I re-added all of my measures and calculated columns to the second table (re-uploaded version of original table)

When I add rows to the table before measures and calculated columns are added and refresh, they load in without issue.

As soon as I add measures and calculated columns, then it seems to be stop retrieving new rows from the data set.

[TameshDoobay]

I found this post:
https://community.fabric.microsoft.com/t5/Desktop/Calculated-tables-or-calculated-columns-causing-re....

It looks relevant to my issue. I'm going through it. Will defer to that link as solution if it works for me.