Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
dsapelak
New Member

Using PowerBI to pull dynamic data source

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.

2 REPLIES 2
Seth_C_Bauer
Community Champion
Community Champion

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

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
ankitpatira
Community Champion
Community Champion

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

 

Capture.PNG

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors