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
Hi Khushboobarai ,
You need to connect Power BI to Azure Blob Storage using proper authentication method (SAS token, storage account key, or Azure AD).
Once that connection is set up, publish the report to Power BI Service and configure scheduled refresh.
That’s the only way Power BI can automatically pick up new daily files. By default it would be full refresh, if you need incremental then your dataset must have appropriate data time column.
If this post helps, please accept this as a solution. Appreciate your kudos.
Thanks,
Pallavi_r
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
