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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I
Helper I

Refreshing excel pivot table connected to a tabular cube in

Hello everyone, 


I exhausted my searches online, getting me to solutions not relevant to my problem. The subject of refreshing excel through can take you to many places. 


We currently have an excel, with one worksheet, with one pivot table, connected to a tabular model deployed to a server. 


We want to collaborate/share that spreadsheet with other users across the company using, but we are hitting a wall while attempting to do that. 


The pivot table on the worksheet has drill through capabilities, allowing us to drill from a product category to children products underneath it. This will naturally generate a query to the tabular server to get the products underneath a given product category. That's where the problem starts. 


What I have tried so far:


  • I placed the spreadsheet on my One Drive for Business, opened through using the "Conect, Manage and View Excel in Power BI" option
  • The spreadsheet now shows up under the "Reports" section, with an Excel-like button next to it
  • When I try to open it, it gives me a warining that says: Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries? The options are "Yes" and "No", I click on the "Yes" button. 
  • Once I click on the "Yes" button, an error message this time pops up: External Data Refresh Failed. We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh: NameOfMyConnectionToTabularModelInExcel. I click on the only option: OK. 


The spreadsheet now shows up just like it would be in excel or excel online. I can even pin sections of this worksheet to a dashboard if I want. 

But I cannot drill through products as this spreadsheet apparently is not able to get to the server with the tabular model. 

I do have a gateway setup between and my tabular model server. I can consume models from that same server through, but I cannot refresh this spreadsheet. 

Is the drill-through something possible? Anyway I can make this work? Can I change/manipulate the connection behind this excel that I just uploaded?


Thanks in advance for your help. 

Advocate I
Advocate I

Hi - Were you able to get this to work. I have a similar problem?
Frequent Visitor

Hi, were you ever able to get this to work? I am running into the same problem. Thanks!

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors