Forum Discussion

BrendenS's avatar
BrendenS
Frequent Visitor
2 years ago

Refresh Issues in Workspace Only

Hello Community,   I have a dashboard that is connected to only two data sources, SharePoint and Azure Data Lake Gen 2 Blob Storage (through access keys).  This dashboard locally refreshes on the d...
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BrendenS 

 

Given the error message and the context, there are a few areas we can explore to troubleshoot this issue:

  1. Data Source Credentials and Permissions: Even though you've double-checked the data source credentials, it's worth revisiting the permissions, especially for Azure Data Lake Gen 2 Blob Storage. Ensure that the service principal or the account used by Power BI service has the necessary permissions (Storage Blob Data Reader role at a minimum) on the Azure Data Lake Storage account.

  2. M Script and Query Folding: Since you mentioned that there could be an issue with your M script, it's important to review if the query folding is happening as expected. Query folding is crucial for performance and successful refreshes, especially with large datasets. If certain transformations prevent query folding, it might lead to issues during refresh in the service. For more information on query folding, you can refer to: Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn

  3.  Firewall and Network Configuration: If your Azure Data Lake Gen 2 Blob Storage has firewall rules or virtual network configurations, ensure that the necessary exceptions are in place for Power BI service. The Power BI service IPs might need to be whitelisted to allow access to the data.

 

 

 

 

 

Best Regards,

Jayleny

 

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