My cost management billing analysis exports to a storage account (blob).I use Power Bi to Get Data>Azure>Azure Blob Storage.The data loads and shows all the csv files that are exported into the blob. I can get this to work for the current day but im looking for a way to make the query use the newest set of data. The newest set of data includes all the old data as well. Is there any way to set up the newest csv file to be used for the query?

btahir in power query, sort by date modified and then select keep rows and choose one. So basically in Power query you will have most recent file and then you can use that to feed to your power bi visualization.

Power BI Azure Blob Storage | Microsoft Fabric Community

8 Replies

parry2k
Super User
7 years ago
btahir when you read files from blob storage, do you have timestamp for the file, if yes, you can keep the most recent file and remove other rows before reading the file that way you always have most recent file.
- parry2k
  Super User
  7 years ago
  btahir i see there is date modified property which can help to get the most recent file.
- btahir
  Regular Visitor
  7 years ago
  Im very new to PowerBI so please forgive my ignorance.
  Do you delete the date column in the azure csv file or do I delete that column in PowerBI?
  Some of my visuals use the date as a reference. Will I lose that ability?
  Below are some screen shots of what im seeing:
  - parry2k
    Super User
    7 years ago
    btahir in power query, sort by date modified and then select keep rows and choose one. So basically in Power query you will have most recent file and then you can use that to feed to your power bi visualization.

Forum Discussion

Power BI Azure Blob Storage