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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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