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.
Solved! Go to Solution.
Import the excel into your report. Open Advanced Editor, copy the MCode and close and then go to the Sharepoint source Table open Advanced Editor and replace the MCode with the copied MCode from the Excel Table.
If you had made transformations to your sharepoint data, make sure that you only add the MCode just from the let section up to the first transformation line.
Delete the original Excel table as you don't need it.
Thanks
Joe
If this post helps, then please Accept it as the solution
Import the excel into your report. Open Advanced Editor, copy the MCode and close and then go to the Sharepoint source Table open Advanced Editor and replace the MCode with the copied MCode from the Excel Table.
If you had made transformations to your sharepoint data, make sure that you only add the MCode just from the let section up to the first transformation line.
Delete the original Excel table as you don't need it.
Thanks
Joe
If this post helps, then please Accept it as the solution
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 |
---|---|
104 | |
104 | |
87 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |