Power BI Push Dataset

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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