Historical data when changing data sources every month

[Fedmike]

Hi all,

I have a report that pulls from two different .xls spreadsheets.  Every month, I would point the data source to a new spreadsheet, refreash the data, then publish it.

My question is: How can I make a visual from the historical data that I have already published each month?  Everything in PBI has already been set up, and all I do is point to the new spreadsheets.  Because I simply point .pbix to the new data each month, PBI longer have any access to the older spreadsheets, thus, I cannot make an historical graph with some data from my old spreadsheets.

Any tips on how I can do this?

Thanks,

Mike

[Greg_Deckler · Accepted solution]

Create a separate Folder query that does an Combine Binaries to import all of your historical data. This data will go into a separate table from your current data.

[Fedmike]

Thank you!

I did do this a while back and I encountered what seems to have been a row limit (1000?) with all the spreadsheets I had.  Not sure what I did differently this time (perhaps I checked avoid errors or something during import) but it seems to have loaded it all in this time...  I did remove some columns too...

What is the limit though?

Mike

[Greg_Deckler]

I'm not aware of a limit on the number of rows.