Azure Blob -> Powershell/Azure functions/Datafactory -> Azure Table

Question

question

UmaJanakaraj-8006 asked Jun 10, '20 kzar commented Jun 16, '20

Azure Blob -> Powershell/Azure functions/Datafactory -> Azure Table

Hi All,

Is there any possibility to extract the data from BLOB, transfer the json value in a specific column to fetch required value using powershell script, datafactory or azure functions and finally the process data to be loaded to the destination - Azure table storage!

To my knowledge, I have done so much of research to find out the possibility, but left with none!
If not possible, then why? We are trying not to use SQL server that's the reason trying to figure out between storage options.

I believe we can load data from BLOB to BLOB, if so, can we get it done the processed data and load another BLOB and fetch the data for Power BI reports?

This is mainly for O365 Stream audit log data.

Please help me with your solution.

azure-storage-accounts

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sumarigo-MSFT · Jun 12, 2020 at 05:34 PM

@UmaJanakaraj-8006 Firstly, apologies for the delay in responding here and any inconvenience this issue may have caused.

Can you please explain what exactly are you trying to accomplish?

0 ·

UmaJanakaraj-8006 Sumarigo-MSFT · Jun 15, 2020 at 07:01 AM

@Sumarigo-MSFT Thanks for your reply. I wanted to do ETL using any of the above mentioned combination without using SQL. In short, what I am trying to achieve is explained in this url : https://techcommunity.microsoft.com/t5/microsoft-stream-blog/global-admin-pro-tip-learn-how-to-build-video-analytics/ba-p/365267 But it has the source data from SPO; Instead, I'd like to use storage options BLOB/Table as source/destination and then pull the data to Power BI; Do you think is there any options available to accomplish this task?

0 ·

kzar UmaJanakaraj-8006 · Jun 16, 2020 at 05:01 PM

Question is: what do you have on blob? Are there files with metadata or csv files with data or something else. Having that it is possible to create a simple parser on powershell\logic app and store results in Azure Tables.
Power BI works with Azure Tables very well.

0 ·

Answer 1 · 2020-06-16T14:55:16.983Z

Sumarigo-MSFT answered Jun 16, '20

@UmaJanakaraj-8006 This is a Power BI question. Their documentation doesn't show explicit support for Azure Storage but there may be ways to do it.

I'd recommend posting your question in Power BI forum it would the better medium to get better help since the issue doesn't seem to be storage, Power BI community is a better place to get help on your scenario. These forum community members could provide their expert guidance on your scenario based on their experience.

Thanks.

Kindly let us know if the above helps or you need further assistance on this issue.

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question