Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi Petr,
How your refeshing the data.
Regards,
Bajee.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |