How to Re-Scan or Re-Merge files in Power BI Desktop Query Editor?

[dualsweat]

Hello, 

          We have a system where a .csv file is uploaded every day to an Azure blob. The .csv file contains information on our different warehouse locations and their respective telemetry data. We recently added a new warehouse location, but when the Power BI service scans the .csv's in the Azure Blob, Power BI does not visualize the new warehouse location data. However, it continues to update the original warehouse location telemetry data every day. Is there a way I can get Power BI Desktop to "re-scan" the data in the Query Editor so that Power BI will now account for the new warehouse and its respective data?

Thank You,

M.-------

[TeigeGao · Accepted solution]

Hi @dualsweat ,

According to your description, my understanding is that you have changed the data source schema, you need to refresh it in PowerBI.

In this scenario, we can only re-import the data source until the latest version of PowerBI, here is a similar feedback: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11695368-handle-model-schema-chan...

Best Regards,

Teige

[dualsweat]

Hi Tiege,

             Thank you for the quick response. Yes, I believe you have answered my question. I appreciate it.

Thank You,

M-----