topic Re: Using PowerBI to pull dynamic data source in Developer

Using PowerBI to pull dynamic data source

dsapelak — Thu, 15 Sep 2016 16:52:33 GMT

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.

Re: Using PowerBI to pull dynamic data source

ankitpatira — Mon, 19 Sep 2016 01:40:41 GMT

@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.

Re: Using PowerBI to pull dynamic data source

Anonymous — Mon, 19 Sep 2016 03:00:47 GMT

@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?