Using PowerBI to pull dynamic data source

[dsapelak]

Community,

I save a sql server table once per month with a date at the end of the name.  Same fields every month, it's a snapshot of our business.  Something like 'Business_Data_08312016'

I'm trying to figure out a way to create a PowerBI report that looks at a rolling 13 months-worth of these tables.  The only way I have figured out so far is kind of terrible, which is to make sproc that unions all of these together into one big table.  It works but it's a major data duplication that doesn't seem necessary.

I am open to any ideas.

thanks.

[Anonymous]

@dsapelak "Major data duplication".. A union will only pull the unique records... Are you trying to reduce the record size, or just determine what is the most efficient way to extract the data?

[ankitpatira]

@dsapelak If you use power bi desktop easiest way is to use sql queries to import data from tables. So you can type in sql queries that looks at all the tables of the past 13 months and bring in their data.