Forum Discussion

KamKam's avatar
KamKam
Frequent Visitor
5 years ago
Solved

How to Automate Binary Extraction into Seperate Queries

Hi Power BI Community,   I have a dataset that has a column with Binary values in it. When I click on one of the binary values it opens an entirely new table. I would like to extract the data in th...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey KamKam ,

     

    yes, the files have to have the same format.

    But if you want to automate things, they anyway have to have the same format. If every file is different you have to load one by one and then after you changed the files you can combine them again.

     

    Does this help you?

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey KamKam ,

 

you can do a lot with M and the functions.

What format do your binary files have?

 

Best regards

Denis

KamKam's avatar
KamKam
Frequent Visitor
5 years ago

Thank you selimovd.

 

I ended up doing it manually.

 

I don't think that Power BI is the tool for ingesting the large amount of data that I was working with. When I clicked on Save & Apply in the Query Editor my machine ran out of RAM.

 

I will have to find a new tool for cleaning the data.

 

Thank you for your assistance.

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey KamKam,

     

    that depends if course on the amount and complexity of your data and the power of your notebook.

    But for huge or complex amounts there are just physical limitations. Check the Azure techniques like data factory or synapse for these kind of situations. They are scalable and made for more complex scenarios.

     

    Best regards

    Denis