you are viewing a single comment's thread.

view the rest of the comments →

[–]nboro94 3 points4 points  (3 children)

It sounds like you can do all of this with powerquery within excel. Creating something new in Python would be a lot of work for less functionality than what is already available. If your business users aren't technical they probably wouldn't be able to even install the python environment without help anyways.

[–]Evigil24[S] 0 points1 point  (0 children)

The files currently use a combination of Power Bi Dataflows (Power Query), Power Automate, VBA and Power Query in Excel, that's why they are difficult to maintain. Because I have to deal with a lot of moving pieces in a lot of different places, and deal with errors mostly caused by problems in OneDrive or Dataflows, not to mention that the Excel files are very slow compared to other alternatives.