Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
BrendenS
Frequent Visitor

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 desktop app pbix file with no issues.  When the same dashboard is published to the premium capacity workspace the dashboard will not refresh successfully and returns an error with the Azure Data Lake table "AZURE_ERROR_MATRIX".  I have double checked the data source credentials and everything is connected correctly.

 

Any thoughts on what I may be missing?  I am running the latest version of PowerBI desktop. Other dashboards with the exact same design have no issues. Recently read there could be an issue with my M script? This is a new issue I have never encountered before, could someone explain if they agree?  Thank you!

 

Capture.PNG

 

 

 

 

 

 

 

Reference: Troubleshoot refresh scenarios - Power BI | Microsoft Learn

3 REPLIES 3
v-jialongy-msft
Community Support
Community Support

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.

dcrow5378
Resolver I
Resolver I

Just curious, is your Gateway updated as well?

Have not checked recently but this model does not require gateway as all the data sources are in the cloud.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.