How to include hardcoded table data in a Power Query rather than sending a seperate source file

[JollyRoger01]

I have seen a lot of users on here post queries that include tables in some weird binary format that saves having to also send the data source e.g.

Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlSK1Yl......

Can someone please tell me what this is called and how I can translate my csv file into this format so I can just post a single query on the forum that people can run without additional files (in Excel)?

[v-kelly-msft]

Hi @JollyRoger01,

You could decode the text into binary format using Binary.From or Binary.FromText:

https://docs.microsoft.com/en-us/powerquery-m/binary-fromtext

https://docs.microsoft.com/en-us/powerquery-m/binary-from

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[AlB]

Hi @JollyRoger01

Just go to "Enter data" and paste your data there. PQ will automatically create a new query with that code at the beginning for you

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[JollyRoger01]

I think this might be a version thing. I am using Excel 2016 and I don't have that option. I can do so in Power BI Desktop though.