Storing Data within Power BI

[Anonymous]

I have an automatic daily Excel report of unpaid invoices, typically around 50k lines long. As invoices are paid, they drop off of the report.

Since it is beneficial to keep track of every invoice, I have been manually updating an Excel file where I add each new day's report and remove the duplicates (ie, the ones that were unpaid yesterday and are still unpaid today), effectively creating a historical report of ALL invoices.

Is there a way for Power BI to do this for me so that I only need to provide the daily report? It would essentially require the historical data to remain in the .pbix file and I'm not sure if this is possible.

Thanks!

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please refer to this case.

[Anonymous]

Yep. Power Query is made for this type of thing. Do you have access to that?

[Anonymous]

Good question. Didn't know they were separate things. Guess I'll do some research. Thanks!