Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
@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?
@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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
3 |