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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
bsheffer
Continued Contributor
Continued Contributor

Can't see all my datasets in my premium workspace when inserting a pivot table using From PowerBI

I have the latest version of analyse in excel installed.  I have build permissions on all datasets in the workspace.  I can use "analyse in excel" from the power platform to create a spreadsheet that accesses that dataset.  However, if I just open a new spreadsheet and try to insert a pivottable and use the From PowerBI option, only 2 datasets appear in the Power BI Datasets menu on the right side of the spreadsheet.  There should be at least 30 of them.

 

I've checked my file->options-> trust center and they are all set according to documentation.

 

why can I see just 2 of the datasets and not all of them?

1 ACCEPTED SOLUTION
bsheffer
Continued Contributor
Continued Contributor

removing my email and permissions from the permission list for each dataset allowed all of the datasets to appear (and not just the ones I had specified build permissions).  Of course now I see the objects for the usage reports as well but at least I can see everything.

View solution in original post

2 REPLIES 2
bsheffer
Continued Contributor
Continued Contributor

Added the build permission to some of the rest and it took until the next morning until they appeared.  But they did appear.  This doesn't explain why some of the developers can see all of them and I can't.  Is there a tenant or user setting I should be using instead to give build permission to any datasource in that premium workspace?

bsheffer
Continued Contributor
Continued Contributor

removing my email and permissions from the permission list for each dataset allowed all of the datasets to appear (and not just the ones I had specified build permissions).  Of course now I see the objects for the usage reports as well but at least I can see everything.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors