Forum Discussion
Accessing SQL Blobs
- 6 years ago
Yes, Power Query has a "Binary" data type that you can then bend to your will, for example by declaring that you want to read that binary as a PDF.
Just add the blob to your SQL view columns.
Here's an example where I pull a bunch of CSV files out of their blobs (the [Content] column)
#"Invoke Custom Function1" = Table.AddColumn(#"Renamed Columns1", "CSV", each #"Get CSV file"([Content])),
via a custom function where I do some basic transforms:
Get CSV File =
(File) => let
Source = Csv.Document(File,[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.Csv]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),....
- Anonymous6 years ago
Thank you. I apologize, for getting upset.
How can that, at least, be done? I cannot find any good and clear instructions on doing so.
Hi Anonymous ,
You may refer to the article: How to access data from Azure Blob Storage using Power BI.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, Amy!
Would the same thing work for PDFs, as well as CSVs?
John