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
     
KamKam's avatar
KamKam
Frequent Visitor
5 years ago

Thank you for the suggestion selimovd.

 

Unfortunately, this only extracts the values from the first Binary row. I would like to do this for each of the Binary values.

 

Do you have any other suggestions?

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey KamKam ,

 

this is not true. With the combine option, a function is created that combines all files in this folder. Like this you can combine all "binary files" (like CSV) into one table.

Please give it a try.

 

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
 
  • KamKam's avatar
    KamKam
    Frequent Visitor
    5 years ago

    Hi selimovd,

     

    You are right. It did pull the correct amount of rows. However, it has only made columns for the first Binary value. The other Binary values have different columns in them.

     

    For example, this is what the first table looks like:

     

     

    And here is the second:

     

     

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      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
       
      • KamKam's avatar
        KamKam
        Frequent Visitor
        5 years ago

        Thanks selimovd,

         

        Do you think that I could automate this using M Lanugage? If so, do you know how to create a new Query using M Language?