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.
I'm testing a scenario and not achieving what is expected. I have a local folder than I'm using as my data source. In this folder I begin with one xlsx file. In the data modeling steps, I remove the 1st row and then promote the first row as headers. When another file is added to this folder, these steps are not being applied and I end up with 2 rows in the dataset that shouldn't be there (the first being the row I deleted, and the second being the row that should be considered headers) What am I doing wrong?
Solved! Go to Solution.
i created a video to follow the steps to one way to solve this:
Let me know if helps you.
i created a video to follow the steps to one way to solve this:
Let me know if helps you.
Alternatively, instead of first adjusting the main query and applying the modifications to the example query, you can also directly adjust the example query.
yes, is correct. The video is the long version to explain what is this M Code to Paste in Sample Query. (Remove Rows, and Promote Headers).
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |