Apologize if this is simple, but documentation on using Python with Microsoft BI is sparse at best.  I'm curious if there is a command that imports Microsoft BI files similar to the read_excel function in pandas.
I have a Microsoft BI file that has 175 worksheets, each of which is currently being exported to excel and saved by hand each day.  Looking for some way to automate, and thought that if I could essentially read each file into Python and then save as an excel file it would save a tremendous amount of time.
Also adding a note that I prefer to save as csv as opposed to xlsx.
From within PowerBI you basically have two options. I don't think there is any possibility to import a PowerBI file into Python.

Inside PowerQuery you add Run Python Script as step to your transformation (Transform menu > Run Python Script). This allows you to use Python in the way you are used to and makes sure all data before this step is moved into a dataframe called dataset. You can simply use dataset.to_excel() to store this dataset as Excel file. Be sure to change the working directory with something like os.chdir() becasue by default it is running in a temporary directory.
Inside PowerBI you can add a script visual. Although it says it requires visual output of your script, the reality is that any code is executed even if the script does not result in a rendered image. The same principal hold as mentioned for the step from PowerQuery. Use os.chdir() to specify your directory and use dataset.to_excel() to export.

For both make sure Python scripting is enabled in the options, should be by default when you have python installed on your machine, else have a look through the menu, you'll easily find it.
Python Solution - Exporting Microsoft BI sheets to excel using Python