Connect Power Bi to Azure Storage

[walid140891]

Hello,

I'm new to Azure and PBI and what I'm trying to do is a bit complecated. I have a SaaS .net core/C# cloud based web app that stores data in Azure Blob storage as an XML file.

part of the data can be deleted by end-user and that works fine. I don't want to lose the deleted data and I want to store the whole data in a different storage (Azure Table, Blob storage, ect...) in the moment of deletion or before it, to use it as historical data in PowerBI reports.

1. Would you please recommend a best way to collect data from the blob storage? I'm thinking about using an azure function that should run through the data and collect it every (x Days/Hours).
2. What should be the better datastore (in terms of cost/ performance and power bi access to it): another blob container or an azure table for example?
3. If we are going to choose for example an Azure Table, is there a way to connect to it from Power BI desktop without having to enter the keys or any sensitive data? because the reports will be shared with other people and published to the online portal in their workspaces.

I appreciate your help specially if someone can present somekind of architectural model to follow or any thing that can put me on the right line.

[Anonymous · Accepted solution]

Hi @walid140891 ,

As far as I know, we must provide an account access key if we want to connect to the Azure blob from the Azure portal.

For reference:

How to access data from Azure Blob Storage using Power BI

I think the users don't need to enter access key ,when you publish your report to Power BI Service and configure the credential correctly.

Here is an offical blog about Azure and Power BI, I hope it could help you.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.