Forum Discussion
Data Connection in Febric from Microsoft Azure Storage Explorer (Azure blob Storage)
It works in Power BI Desktop because it’s using your local access to the Blob container (public URL / Storage Explorer context). That access does not exist in Power BI Service.
Power BI Service has no authentication to Azure Blob Storage, so it can’t refresh on its own.
Reconnect Power BI to Azure Blob Storage using a proper authentication method (SAS token, storage account key, or Azure AD).Please check this link for your reference - https://learn.microsoft.com/en-us/power-query/connectors/azure-blob-storage
If this post helps, please accept this as a solution. Appreciate your kudos.
Thanks,
Pallavi
Can you tell me how can i do incremental refresh? cause i dont want it to load all from the 1st file there are lot of data
Hi Khushboobarai ,
Please check these link.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure
You need to have a date time column on top of which incremental refresh works.
Since this is not database table, this link will be helpful. One important point to note is incemental refresh is being done at row level, not at the file level. It checks the new date entry records and pulls that.
If this post helps, please accept this as a solution. Appreciate your kudos.
Thanks
Pallavi