Forum Discussion
Problem with reference table and refreshing
Hello, I have a main table in my project (5mln rows) I created second table which based on main table (I add here a few steps). I thought, that when I refresh my project, then only main table do...
amitchandak
Super User
Super UserAnonymous , You might have done that duplicate or using the option add as new query.
In place of that you should create it using table function
example
Source = Table.Distinct(Table1)
Check power query table function:https://www.youtube.com/playlist?list=PLPaNVDMhUXGalVK1yOQ8hV2kWTNsZW5Gq
Or create in DAX using summarize or distinct