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.
One of my data sources for my report is a csv file on a shared drive. On occasion, even if the csv file has changed, the updates are not included during the scheduled refresh. I swear I saw this problem addressed once in either Guy in a Cube or by Chris Webb and it involved some advanced editor tweak to force it to refresh even if the server timestamp was out of date indicating no change. Everything else is fine (include in refresh is enabled, etc.). Does anyone have any ideas?
Hi @erf01 ,
Can you show me the screenshot of the Configuration Plan Refresh page? I need to know what you have configured in order to find the appropriate troubleshooting direction for you!
And about advanced editor, you can add the Table.Buffer function to your query. This will effectively load the entire table into memory, and this could help with forcing a refresh. Here's an example of how you might use it:
let
Source = Csv.Document(File.Contents("\\shared\path\to\your\file.csv"), [Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),
BufferedTable = Table.Buffer(Source)
in
BufferedTable
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.