Hi,
Power BI desktop file is connected directly to a DB and I am able to refresh with no errors
Power BI enterprise gateway is failing due to the following error “Column ‘X’ in Table 'Y ’ contains a duplicate value ‘1367’ and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table”
I have checked and there is no duplicate of ID 1367 and even if there was the desktop version should fail. Any suggestions?
A few things you could do here. You could first try to clear the Data Cache and Q&A Cache. You could turn off the “Auto Detect Relationship Function”
Also you could delete the row in the database as a workaround and that would let you refresh the data.
Thanks- I will try and update but wouldnt clearing the cache still mean it would fail on desktop refresh as an issue?.
It just seems strange that Power BI desktop refreshes directly from a postgres DB but via the enterprise gateway which connects virtual machine to database i get this error. Also its annoying because as the virtual machine is on azure i am reliant upon external IT.
Hi @Hitman - Don’t see the reason why you might be getting this issue. Ideally it shall work on Service also if it is working on Desktop.
Can you share PBIX file to check if there is anything incorrect?
Thanks
Ankit J
Hi @Hitman, we’ve noticed that no response has been received from you since a few days ago.
We just want to check if you still need further help with this post?
In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @Hitman, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,We hope you’ll give your insights on how we can further improve the Support forum. Thanks!
Hi all,
Still do not understand why this refreshed in desktop and not service but i added the step remove duplicates in query editor and worked
Thanks all