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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Pradeep777
New Member

In Excel, Duplicate datasets are found while searching for a dataset name in Power BI datasets while

In Excel, when I use the 'Get Data' option, then choose 'From Power Platform' followed by 'From Power BI,' and search for a dataset called 'SARCS Prod,' I see multiple datasets as shown in the attached image. However, if I don't search and just scroll, I don't see any duplicates. On the Power BI service, there's only one dataset and one report named 'SARCS Prod.' Additionally, when using Excel on Azure VDI, I do not encounter duplicate datasets; this issue occurs only on my local desktop. What could be causing these duplicate datasets to appear when searching Power BI datasets, and how can I resolve this issue?

 

 

Excel_GetData_PowerBI_Datasets.JPG

2 REPLIES 2
rajendraongole1
Super User
Super User

Hi @Pradeep777 - as checked in snapshot, verify that there's only one dataset named 'SARCS Prod' in the Power BI service.Log into the Power BI service different access levels or permissions might cause inconsistencies in how datasets are displayed.Navigate to the workspace containing 'SARCS Prod'.Ensure that there are no duplicated datasets or reports.check that the permissions for the dataset are correctly set and that you have consistent access across different environments.In Power BI Service, go to the workspace containing 'SARCS Prod'.Check the permissions and access levels for the dataset and report.

 

Hope the above information helps

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Hi @rajendraongole1, I have ensured there are no duplicates on the service. I need to check on the permissions and different levels of access now. I shall check and will update here.

 

Thanks for your inputs.

 

Regards

Pradeep

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.