Share via

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

Uma Janakaraj 1 Reputation point
2020-06-10T14:49:44.457+00:00

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
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,814 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sumarigo-MSFT 44,496 Reputation points Microsoft Employee
    2020-06-16T14:55:16.983+00:00

    @Uma Janakaraj 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.

    0 comments