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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
CyrusOC
Advocate I
Advocate I

Powerpivot slicers not working as expected in PowerBI

I am desperately trying to find ways to share tabular data in PowerBI but coming up short. None of the data visualizations really supports tables or matrix to my liking (expand/collapse, drill down, etc.) When I upload an Excel file that has a PowerPivot data model I get the dreaded "This workbook contains external data connections or BI features that are not supported" but I don't know why, I am not trying to refresh the data model, only trying to use slicers on the web page in Excel Online...someone please tell me this is supported?? What check box am I missing???

1 REPLY 1
CyrusOC
Advocate I
Advocate I

Found my answer but not very happy about this. 

 

Excel Online PowerPivot needs wdbipreview=true  

 

http://blogs.technet.com/b/office_online_support_blog/archive/2015/03/06/excel-online-guest-link-thi...

 

Now I jsut need to figure out how to drill back up with Excel Online, why are these tools so diffcult to use form a UI point of view... 😞

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors