Data not refreshing

[Pete_R]

Hi guys,

I am using 4 csv files from local drive as data source.

Was removing some rows from them to validate whether my Power BI report is refreshing the data.

Funny enough 2 sources are refreshing however remaning 2 don't.

Any ideas what could be wrong?

Thanks,

Petr

[bajee]

Hi Petr,

How your refeshing the data. 

Regards,

Bajee. 

[v-jiascu-msft]

Hi Petr,

That doesn't make any sense. The refreshing could be done or not. No half done. Please check these items below.

1. Are these 4 files in a single data model (one pbix file)?

2. Did you test it in the Desktop or the Service?

3. Did you save the files after removing some rows?

4. Could you share some snapshots?

5. Were there any error messages?

Best Regards,

Dale

[Pete_R]

Hi,

I am aaware it seems to not make sense and it doesnt make it to me either however this is what happens.

- using desktop

- having all 4 files for a single pbix

- 3 files are reletad to 4th

- saved the source file after removing rows

- using refresh all the tables to refresh the data, tried refreshing also in the query

- no error message received

Unfortunately cant share snapshots.

Any ideas?

Thanks,

Petr

[v-jiascu-msft]

Hi @Pete_R,

Quite weird. I have a question about "3 files are related to 4th". Is the data in the files related? Or are the files related? Are they independent files? It would be great if you can provide a dummy sample.

Did you import them as 4 queries? Or import from the connector "Folder".

Best Regards,

Dale

[Pete_R]

Hi,

- they are all separate files

- they have common values which are used to link the data in query

- all files loaded from the folder

- cant really share the data

- can any of stesp disrupt the refresh?

- at the bottom also data model attached