Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Our company record sales from multiple channels on multiple platforms. What is the best way to model the data into the one file?
Solved! Go to Solution.
Hi @Anonymous ,
If you have multiple files that have the same schema, combine them into a single logical table. It is a powerful approach to importing data into Power BI Desktop.
More details:Combine files (binaries) in Power BI Desktop
If there are different sources with different column names, Pleaserefer to the following topic to see if it helps you.
Combine different sources with different column names
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
If you have multiple files that have the same schema, combine them into a single logical table. It is a powerful approach to importing data into Power BI Desktop.
More details:Combine files (binaries) in Power BI Desktop
If there are different sources with different column names, Pleaserefer to the following topic to see if it helps you.
Combine different sources with different column names
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, they are all downloadable csv files. A couple of different shopify accounts and an amazon source.
Would you recommend dropping these into one excel file?
Hi:
Can you access the source, like sql server? If they are csv's or excels,you can group the same structured ones in folders and drop in the latest week ,each week and Power BI can load those routinely.
Not knowing your situation that well, there are probably acouple-few ways to get it going but best if they all come from the same source.
It's worth spending some time on becasue how you set up your model is a big deal.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
25 | |
23 | |
14 | |
11 |
User | Count |
---|---|
78 | |
63 | |
47 | |
17 | |
12 |