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 everyone,
I am using an excel data source for power BI and some cells are merged, when i import it to Power BI, the cells get unmerged and the value null is given. So how can i merge cells in Power BI?
Thanks in advance,
Hi @sr12 ,
You can import the data into power bi and merge it through power query.
Create some data:
1. Enter power query through transform data.
2. Select the column you want to merge, right-click the mouse, and select Merge Columns.
3. Result.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
we can't merge cells in powerbi. Usually we don't suggest to have merged cells in Excel data source, you need to unmerge those cells and restructure the raw data.
The merged cells will generate some null values columns in powerbi, you can also try to delete those columns as well.
Proud to be a Super User!
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |