Forum Discussion
Issue while importing binary data. combine files feature makes other columns disappear
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
lbendlin Thanks for taking a look at my problem, but I am relatively new at power BI and I dont know how to build and share a table while ensuring it stays as binary data.
I am importing this directly from the database, and all the data is in binary format, so I dont know what is contained until I transfer the data format to the right file origin (#37 IBM EBCDIC. For example, the first row in my table should Contain many rows with "HP" seen from the screenshots earlier). The table is quite large (over a million rows) so I built a sample set of the first 25 rows in the table. When trying to export that data from Power BI, the Webpage gives a result that shows the entries incorrectly (1's and 0's) rather than the actual binary data. (As seen below). I still added the file (Link: New Report (1).xlsx ), but let me know if this is a visual bug, or there is another method I can use to share the actual data with you.
Sorry for all the text, I just want to provide as much detail as possible! Thanks again,
Marco C.
Data when viewed through the website after publishdata as seen in power query editor
It would be better if you could post a sample raw file somehow. Understand that it might be difficult to sanitize.
Oh, I think I might have a way to do that. let me know if this works as well, Thanks!
Link: Test-Data.xlsx
Note* Some of the rows are in the correct format already, the only ones I need to transform have the "Binary.From..." for each of the fields.
Thanks for the quick response!
sorry, I meant the actual raw file. The Excel version only has the formulas without data.