Self-serve Power BI report generated by streamlit/python app

Using Streamlit
1

I have fact tables in BigQuery and are mapped with dimension tables. I want to create some insights using fact and dimension tables and generate a power BI report using python. I want to generate power BI dashboard (.pbix file) which contains the insights using the fact table.
Below are the key objective I am trying to implement to meet my goal.

  1. Take the query result into dataframe(df)/OR respective
  2. Create a template(graph/chart) that supports power BI(May be custom visual in power BI)
  3. Update the template with query result
  4. Generate a .pbix file that can be import into power BI desktop.

Can anyone please suggest how can i achieve this goal.