Forum Discussion
QTS_JordanB
Dec 01, 2023Copper Contributor
External Data Properties
I specialize in managing inventory in excel and my data comes from an external database that through a query is imported into excel. What I want to know is, in regard to the external data propert...
SergeiBaklan
Dec 02, 2023Diamond Contributor
Manually added column is not in sync with records return by PowerQuery. For the workaround try to google for self-referencing tables. One the first posts is Self Referencing Tables in Power Query :link:- Excelerator BI
- QTS_JordanBDec 04, 2023Copper ContributorThanks for the reply!
Do you know if the process is the same for a connection vs a Query?
My data is pulled from a database not an excel spreadsheet and I am having a hard time trying to translate to a connection.