Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
New Power BI user here. I've got 4 source folders connected to my data model and each week I drag my new csv reports into the folders and click refresh. Everything has been working perfectly for months. Now for some reason, one of the data sources is no longer updating. The other 3 sources continue to update without issue.
In Power Query I can see that the file has been accessed, however it doesn't add the new data rows to the bottom of my table either in the query editor or main interface:
I have 'Enable load' and 'Include in report refresh' both selected in the query editor window.
But the new data rows do not pull through to my reports. The latest data shows from early March and all my data from the rest of March and the beginning of April is missing.
I have tried re-connecting to the data source however query editor shows it is reading those files... Please can someone help?
Thank you
Quenril
Solved! Go to Solution.
Have you checked any possible filter applied in the step later ? if possible share your pbix file ?
I think you should copy the pbix and (after the source step you have shown) attempt to filter out all the files except the one that is causing you a problem. Step through in Power Query and see if you can identify the step where the data 'disappears'
Have you checked any possible filter applied in the step later ? if possible share your pbix file ?
Hi AmiraBedh,
Oh gosh, oh course! What a schoolgirl error! Thank you, I had temporarily added a filter in the query editor and forgot to delete it afterwards. Thank you so much!
Quenril
Things happen 🙂
Glad to help !
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |