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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
martapbix
Frequent Visitor

Dataset not visible when connecting via Excel

Hi,


I was trying to connect to PBI directly from Excel.
I could see only 15 or so datasets, not all the ones I have access to, neither could I search them in the search box.

 

Next time I tried again and I could see a dataset that I was looking for last time, but another one 'disappeared'. Still not all of them are listed there.

When I enter via PowerBI service, I do have access to the dataset that I'm looking for.

 

Any ideas?
Could it be a matter of changes newly implemented in the datasets and synchro?

5 REPLIES 5
v-tangjie-msft
Community Support
Community Support

Hi @martapbix ,

 

Refer this , please check what you need to be aware of when connecting to Power BI datasets in Excel:

vtangjiemsft_0-1696485905714.png

 

Is the dataset you are not visible in excel a shared dataset?

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Hi,
Thanks, i checked that and everything looks ok, also other users can see (we all have the same privilages).

Hi @martapbix ,

 

Do you and other users only see 15 datasets? Please check whether the owner of the visible data set is only you. Are data sets invisible to you shared with you by others?

 

Best Regards,

Neeko Tang

christinepayton
Super User
Super User

You're logged in with the same account in Excel, right? 

Yes, bc I can see the datasets, just the limited amount of them.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

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.