How do I Manage False Duplicates?

Hi Anonymous 

Apologies for the late reply - I am waiting to get my admin rights fixed so I can view the logs.

I've done some further testing today by creating a new .pbix file and writing a query that returns very few fields from the table I have been having trouble with - and there are no joins. This stand alone table with no joins in the query and no relationships within Power BI does not return any duplicate record errors when I publish it to the service -  and in this test I did not have to use Power BI functionality to 'remove duplicates'. 

When I use the gateway and use 'refresh now' to refresh the table I get the 'last refresh succeeded' notation when viewing the dataset, but my visual is blank. I have exported the pbix file and find that of the 8 fields I have extracted via the query, 2 are blank - product code (primary key) and product description. 

It seems now the issue is between the data warehouse and the gateway/service. We are using an ODBC connection to query the data warehouse. I've also reached out to our external dba who built the data warehouse to see if he has experienced this before.

Has anyone else had a similar problem? I'm not getting any error messages, as far as refresh history goes, manually refreshing the pbix and publishing the data works as expected but using the gateway does not as some fields are entirely blank. I don't have access to logs at this point but since the gateway refresh was successful - would they help?

Thanks!