Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to pull an .xlsx file from Sharepoint and convert it to CSV in python by running a script. After the file would get converted to CSV, I have a script written to perform some data cleanup. After that, I may have to convert it back to a .xlsx for my subsequent data cleanup steps executed in PowerBI not Python. Can someone advise?
cannot help with the pyton code, but why bother with the conversion? why not pulling XLSX to PowerBI directly and doing all the data cleanup there?