Forum Discussion

Mornagli's avatar
Mornagli
Icon for Helper III rankHelper III
4 years ago

Turn binary column into several tables

Hello, i send to MPBI an zip file that contain sveral files, after i unzip the file i get this table: If i click on each binary cell, i can open it to an table, but i want to make this procces...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Mornagli 

You need to unzip the file first into a folder, then Get data / Folder with your desktop, and then Cilck on Combine, Let Power Query do the work for you. 

Mornagli's avatar
Mornagli
Icon for Helper III rankHelper III
4 years ago

Thanks aj1973 , Can i with Advenced Editor, split this binary column to 4 differents tables?
Each table will include only the specific value?

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Mornagli 

    You would need an M code savvy for this 🙂 

    Sorry I can't help you with that.

    Just let me add something, even when you get what you want Power bi or Power query will only refresh the data that already exist in the Dataset and will not refresh the amount of files when you add or delete a file from the source, to the contrary you will expect an error message upon refresh.

    Good luck