Forum Discussion
Setting up power query for an existing table
May I seek the community's advice on how to set up Power Query for an existing table in a data model?
I'm quite new to this and all tutorials guide you to start from scratch.
The table has been manually maintained by copying/pasting new rows of data and there are a number of calculated columns and measures associated with it. Would like to be able to import the data from an excel file stored on drive, while keeping the calculated columns/measures intact. Thank you.
Not sure I understood the logic. In general Power Query is just structured data source for the data model. You may query as many tables as needed, includes one from another files, combine them and load to data model. Here add DAX measures and calculated columns (better to avoid them, in majority of cases only measures is enough) and aggregate results into PivotTables. Alternatively you may aggregate with Power Query and return result as structured table. With that only Refresh All is required.
- Thanks. I'm just asking how to set up the Power Query so that the data loads into the existing table that I have (keeping measures and calculated columns intact) instead of loading as a new table.
