Forum Discussion

Khushboobarai's avatar
Khushboobarai
Helper IV
6 months ago
Solved

Data Connection in Febric from Microsoft Azure Storage Explorer (Azure blob Storage)

Hi , Can someone help me with the data connection and auto update or schedule refresh. So , Client saves all their data in azure blob storage, and they gave me reading access only in Microsoft Azure...
Need Help
  • pallavi_r's avatar
    pallavi_r
    6 months ago

    Hi Khushboobarai 

     

    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

Mauro89's avatar
Mauro89
Super User
6 months ago

Hi Khushboobarai,

 

Since you have Pro license only, your refresh options are limited. What you can do is:

For Power BI Desktop → Service with Pro:

  1. Set up scheduled refresh in Power BI Service:

    • Publish your report to Power BI Service
    • Go to the dataset Settings → Scheduled refresh
    • Configure credentials for Azure Blob Storage
    • Set refresh schedule (up to 8 times per day with Pro)

  2. Ensure your connection uses proper authentication:

    • In Power BI Desktop, when connecting to Blob Storage, use Account Key or SAS token authentication
    • These credentials will be stored in Power BI Service for scheduled refresh

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution

  • Khushboobarai's avatar
    Khushboobarai
    Helper IV
    6 months ago

    I did it with the link of a container where the credential isnt asked to put in desktop , am I doing wrong? beasue in desktop, Im not facing any issue with data load, whenever it opens it already updated. but febric requiers each time to publish with refresh from desktop. 


    • pallavi_r's avatar
      pallavi_r
      Super User
      6 months ago

      Hi Khushboobarai 

       

      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