topic Power BI Push Dataset in Developer

Power BI Push Dataset

Anonymous — Tue, 19 Apr 2022 08:35:14 GMT

Hi All,
I'm trying to create Power BI push dataset for real time data and My source is memsql.
Is there way to insert data from memsql to Power BI push datset using Python?
Please help me on this?

Re: Power BI Push Dataset

Anonymous — Fri, 22 Apr 2022 06:56:19 GMT

Hi @Anonymous ,

I am not familiar with memsql, here are some video (blogs) on how to connect to MYSQL and SQL Server using phython scripts in Power BI Desktop. Maybe you can refer to them to try to connect to MEMSQL...

Use Python as a Data Source in Power BI

SQL Server:

How to Connect Python to SQL Server using pyodbc

import pandas as pd import pyodbc conn = pyodbc.connect('Driver={SQL Server};' 'Server=RON\SQLEXPRESS;' 'Database=test_database;' 'Trusted_Connection=yes;') df = pd.read_sql_query('SELECT * FROM products', conn) print(df)

MySQL:

How to Connect Python with SQL Database?

Best Regards

Re: Power BI Push Dataset

Anonymous — Fri, 22 Apr 2022 07:44:41 GMT

Appreciating your help, But our use case different.
Data ingested to memsql/mysql to every 3 minutes and I need to visualize the data in real time but power bi will not support direct query method to MySQL. So I'm creating streaming dataset for real time data. So I need to fetch the query and directly into dataset using service principal method?

Re: Power BI Push Dataset

Anonymous — Fri, 22 Apr 2022 08:29:44 GMT

Hi @Anonymous ,

Please review the following links and check whether they are what you want.

Using the Streaming Dataset UI to push data

Implementing real-time updates in Power BI using push datasets instead of DirectQuery

Power BI Real Time Streaming: 2 Easy Methods

Best Regards