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.
Hello,
I am working on lots of SQL server table data sources.
I need to transform the tables to a Pivot structure, then create charts and visualization on top of the pivoted data . Can I do this with PowerBI without using PowerPivot?
This used to be easy with PowerPivot. However, I am hoping to replace PowerPivot with PowerBI. Can I do that?
Thank you,
Solved! Go to Solution.
Yes, can use the transform tab in Power BI Desktop to pivot your data if needed. Please see the following link.
Yes, can use the transform tab in Power BI Desktop to pivot your data if needed. Please see the following link.
Yes, you would create queries to your source tables and then use a Matrix visualization. Just as easy, if not more so than PowerPivot and pivot tables. Desktop would be your best choice for this.
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |