Forum Discussion
Greetings
Hmm. That's not the procedure at all.
It seems like you are trying to achieve something different. Can you please explain your goals again?
Hi lbendlin ,
Thank you for your percise efficient feedback. You help all of us that are starting out and its appreciated.
Oddly it worked and the dataset opened. I did not restart my computer so that might have been the case. Albeit, going forward i still would like to know if i receive a different format dataset and need to upload it in power bi, how do i do that? Ex: A dataset that has "zip" at the end of the file name with no "XLSX" file extension that needs to be uploaded in power bi. What if the folders are empty?
I know you you extract the folder and rename it, but if it doesnt upload what are the other possible ways to accomplish? Perhaps change the source (path)
Here is a visual.
https://youtu.be/r9hpiyzOOTY?si=1_J_TKzvHc9r0PR4
Ex: A dataset that has "zip" at the end of the file name with no "XLSX" file extension that needs to be uploaded in power bi.You can choose to manually unpack that and then load it in Power Query, or - if the ZIP contains a known number of files and always has the same structure - you can use Power Query code to unpack and extract the files automatically.
Shameless plug: https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Working-With-Zip-Files-in-Power-Query/ba-p/1190186