Straemlit with powerbi , python

Using Streamlit
1

Kindly tell me is it possible to connect streamlit directly with power bi to fecth dashboards

2

Hello Streamlit community. Yes, this is my question as well. Infact, I would extend it that whether it is possible to link Streamlit to PowerBI or Spotfire to fetch dashboards? If it is not possible, is it possible to link Streamlit to the Transformed Data of PowerBI/Spotfire so that we could use that nice transformed/processed data for Streamlit dashboarding.

Thank you.

3

My doubt is also samething. Is it possible to connect to powerbi

4

You can use iframes with power bi embedded url and it just works :slight_smile:

5

How can we embed power bi functionality into streamlit with full functionality?

1 Like
6

Have you published the dashboard already? Thats the first step. Once you accomplish that, let me know and I can walk through the next steps after that.

End result will look like the following page below, the dashboard is fed by a very large dataset, so may need to give it a few seconds to load:

7

My problem is how can I take inputs to Power bi from streamlit and automatically do the report generation

8

Gotcha. Thank you clarifying.

What’s your end goal for the project? Or what are you building?

Power BI itself does have some limited capabilities to except inputs using the “parameter” feature. If you need a drop down with values from a table within your report that interacts with an SQL query, that can be done directly in Power BI without Streamlit.

If you’re looking to publish a form online using Streamlit or something along those lines, you’ll need to setup some form of cloud storage. And you have a lot options available depending what you’re needs are. If you anticipate a large amount of data, a cloud database is a good option. Smaller amounts of data, blob storage is a good option.

9

i want to do the following steps in the picture

(attachments)

Capture.PNG
Capture.PNG1029×335 64.3 KB

1 Like
10

Awesome. A couple of steps to help you get going


1.) Choose a Cloud Database Service that offers an API that can be connected to Power BI. Plenty of options available depending on your budget. A few options are listed below:

  • Snowflake
  • Azure SQL
  • Amazon RDS or Aurora
  • Supabase
  • BigQuery

2.) Decide if you’re going to host you application on Streamlit Community Cloud, or self-host the application yourself. All the major cloud service providers have products available for hosting containerized applications that will require custom configuration and on-going management of the application. Some knowledge of Docker and the Linux command line is helpful for working through this process. Could service providers are listed below:

  • Azure
  • AWS
  • IBM
  • Google Cloud Platform
  • Snowflake (Offers services for hosting private Streamlit applications for internal use)

The Streamlit application can transform/process your data and send information to your database utilizing an API. Once your dashboard has been connected to the database, you’ll have instant access to the latest data available and can be updated using the refresh button in Power BI. Depending on your needs, I would recommend using Power BI’s semantic layer capabilities instead of the direct query features. The direct query feature will affect the performance of your dashboard depending on how large the dataset is. Running dynamic event driven queries triggered by user inputs requires excessive computing that you’ll likely be charged for. Power BI offers features so you can schedule automatic updates for your semantic data layer allowing you to avoid the excess costs that are likely to be incurred using direct queries. In most cases, unless you’re dealing with machine & equipment monitoring data, security, emergency, or other types of data that absolutely needs to be viewed in real-time, the semantic layer is a good option that will help reduce costs.

11

If possible can you please suggest me some other different web applications inplace of streamlit which better support Power bi

12

Streamlit isn’t an application it’s a Python Framework for building custom web applications using the Python programming language.

If you’re looking for an off-the-shelf solution, that doesn’t require hard-coding you might try researching low-code or no-code platforms.