Forum Discussion
Power BI Push Dataset
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
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?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