Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago
Solved

Optimized Way to download specific files from Azure blob Storage

hi Guys, i have structure in Azure Blob Storage like container1 -folder1 -file1 -file2 -folder2 -file3 And now what is the best optimized way to get data using power query? I need to...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi jaryszek,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

I don't think you will see any wiggle room for performance enhancements there.  Can you show a sample Power Query code?  How large are these blobs?

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi jaryszek,

    Thank you for reaching out to the Microsoft fabric community forum. 

    As mentioned by the community member lbendlin, could you please provide a sample Power BI query? This will help me better understand your issue and provide an appropriate solution.

    Thank you.

    • jaryszek's avatar
      jaryszek
      Icon for Super User rankSuper User
      1 year ago

      v-kpoloju-msft  lbendlin  there i no query yet. I am designing architecture for power query. 

      How to make the implementation? Assuming that blob can be huge in the future. 
      There are just csv files which i need to get into power query but i didn't find a way to only download one file from blob storage -> it has to be always filtered with all files first. But this is a good approach? 

      Or maybe just download every file and after that build queries on top of that using filter to direct file? 

      Thank you for your help,
      Jacek