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,
My finance person has a nice excel spreadsheet and I would like to pull that data into power bi. However, the data is not well formed for ingest. Here is an example:
I would like to know if anyone has suggestions on how to handle this data. The Previous month cell and Notes information is important, but I can't figure out how to cleanly extract that data. And I would like to avoid having my finance person rearrange their spreadsheets.
Thanks,
-cj
Solved! Go to Solution.
Hi @jacbob,
I think it's good to have a format like below. Please try out the demo in the attachment. These steps are all applied in the Query Editor.
Best Regards,
Dale
Hi @jacbob,
Could you please mark the proper answer as a solution?
Best Regards,
Dale
I just did. Thank you very much for your help.
Hi @jacbob,
Are all the data the same format? Same numbers of rows and columns. Separate by one blank row. Maybe you can format it using VBA before loading or format it using R after loading.
Best Regards,
Dale
Hi Dale,
Yes, this is the correct format, with a blank row in between and another piece of data in line with other separate data. I thinking of creating a new sheet in the excel that references these one off cells and putting them neatly into rows/columns for better power bi ingest.
Hi @jacbob,
I think it's good to have a format like below. Please try out the demo in the attachment. These steps are all applied in the Query Editor.
Best Regards,
Dale
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |