monthly table with applied steps append into a static?

Question

Hello there...&nbsp;Ive set up a process that was in an access database into powerbi - yes i know, painful.&nbsp;basically every month, I will import a spreadsheet in, create some applied steps to clean it up, and link in current validations based on the max date in there (this is in a seperate table linking to an access database that i do not have the right to change) so in the end i have a validated month end table.I need this to be static, not linked to validations in any way, and be able to repeat the process every month so i have a master static table of monthly validated patients.&nbsp;My idea, was to append this into a master table (I made a static enter data version), and for the next month just replace the above spreadsheet process to next months downloaded file just in the source - so all that linking and cleaning was already done, and just append onto it.&nbsp; But im getting cyclic reference errors?&nbsp;I didnt want to import and keep each monthly file in there along with replicated all the applied steps, I thought i could just keep appending the process in one static table.&nbsp;have i gone about this the wrong way? is there a better wayappreciate your adviceliz&nbsp;

lbendlin · Answer

Power BI has no memory. Continue with your process. Keep your monthly files on a SharePoint for fast and convenient ingestion without the need of a gateway.

omid_motamedise · Answer

Instead of using Referencing, use duplicate query

elizz · Answer

ahh ok thanks, so if i duplicate it, change filename etc can i stop the previous query from refreshing, keep that static if you like.&nbsp; then append them all together to create one table?

Forum Discussion

Related content

% with static denominator

Monthly Automatic Change

Monthly Count not working

Static Outbound IP for Notebook

Total Min/Max measure where and keep the value static