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.
Hey everyone! First time user of PowerbI but longtime Excel/Access user here. I am developing a dashboard through PBI but I need to parse data in one/multiple columns that is a string or non-delimited string. This will help my filtering a slicing in PBI but I was curious if it was easier to do the parse in PBI or Excel? Below is a screenshot of my dataset as it sits in Excel and I would like to find a PowerQuery formula solution in M or a solution in PBI as the data is live and will be published to SharePoint. Thank you!
-ExcelGuy
Hi ExcelGuy,
I would parse it in excel.
I like to have my data as clean as possible to limit the work powerbi has to do.
If you want to try it in Powerbi.
Click on the Edit queries button in the home tab.
Select your query and use the split column button.
Try that let me know if you have any other questions.
Kerry
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |