User Profile
TrItalo94
New Member
Joined 3 years ago
User Widgets
Contributions
Re: Refresh issue SQL DB
Hi, I'm a colleague of filipovski who in the meantime has left the company. We finally solved the problem by adding a step to remove duplicate rows in the Power Query Editor for the two columns that gave us that error. It's still not clear to us why it happened in the first place, since SalesId and the other column are the primary keys of their database tables and as such had no empty/null/duplicate values. Also, when we first wrote about this problem, it would solve itself by just repeating the refresh until it didn't work, but as time passed and more work was done it took more and more attempts to successfully complete a refresh of the data. I suspect it might have been a cache problem, but clearing it didn't solve anything. I would like to ask any moderator if it can set this message as the accepted solution1.2KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.