Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

0

Couldn't load the data for this visual. Duplicate values are detected from data source.

Submitted by Anonymous on ‎12-24-2023 08:45 AM

Our team has encountered an issue with reports generated through Semantic Models utilizing direct Query tables to AWS Snowflake. Until last week, these reports were executing without any problems. However, recently, users have been unable to view their reports due to an error message stating,

"Couldn't load the data for this visualDuplicate values are detected from data source. If it's a DirectQuery model, please make sure data source collation is consistent with this Analysis Services model."


Upon investigation, we have verified that there are no duplicate values in the data source. We are reaching out to seek your advice on this matter. Additionally, we would like to inquire if there have been any recent changes in the service that might be causing this issue.

Status: Delivered
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎12-24-2023 05:54 PM

Hi @Anonymous ,

 

I didn't succeed in reproducing your problem, have you checked the relationships in the report? If you change a 1:N Cross Filter Direction of single to both ，would that mitigate the problem?

 

Best regards.
Community Support Team_Caitlyn

Anonymous
Not applicable
‎12-24-2023 08:18 PM

We attempted that method suggested in a Microsoft Community blog, modifying the dimensional table to crossfilter both dimensions. This approach successfully resolved the issue in the service. However, our semantic models previously utilized a single cross filter, which had been functioning well until last week. Transitioning to a both crossfilter would require a significant effort for all the semantic models.
Is there a way to pinpoint the cause of this recent problem? Please advice.

The same report is executing in the Power BI desktop and fails to execute in Power BI Service.

The problem is observed in reports without any added measures. Everything was functioning correctly until last week when users began reporting issues. 

Anonymous
Not applicable
‎12-25-2023 06:55 PM

Hi @Anonymous ,

 

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

Anonymous
Not applicable
‎12-31-2023 01:51 AM

User @plxtime  raised the same issue as support ticket, and by following the steps outlined, Microsoft was able to identify and resolve the problem.  Now the error reports that were previously affected are now functioning normally again

This conversation is tracked in Community blog-https://community.fabric.microsoft.com/t5/Service/Duplicate-values-are-detected-from-data-source-If-... .

Anonymous
Not applicable
‎01-02-2024 09:38 PM

Thank you for sharing, for other users with similar experiences you can check the comments below. This thread will now be closed.

 

Best regards.
Community Support Team_ Caitlyn

Idea Statuses