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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Helper III
Helper III

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.