Forum Discussion

New Member

8 years ago

Data not refreshing

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 refre...

Microsoft Employee

8 years ago

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
New Member
8 years ago
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
  Microsoft Employee
  8 years ago
  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
    New Member
    8 years ago
    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