Forum Discussion
Need help on Streaming Dataset
Hi All,
I'm creating Streaming datasets using python. I've created streaming dataset to stream one value which is working fine. But when I tried stream multiple values in line chart it's not working. Please help me on this.
Source is - MemSQL
import requests
from datetime import datetime
import time
import psutil
import simplejson as json
import pymysql
import pandas as pd
from pathlib import Path
import schedule
directory =str(Path.home())
connection = pymysql.connect(user="******",
passwd="******",
host="*******",
port=****,
database="******"
)
cur = connection.cursor()
def my_func():
cur.execute("select revenue,order,hour,minute from sample_table")
ls = []
for l in cur.fetchall():
dict_qs = {}
dict_qs['revenue'] = l[0]
dict_qs['order'] = l[1]
dict_qs['hour'] = l[2]
dict_qs['minute'] = l[3]
ls.append(l)
print(dict_qs)
json_data = [{
"Revenue": dict_qs['revenue']
"Order":dict_qs['order']
"Hour":dict_qs['hour']
"Minute":dict_qs['minute']
}]
res = requests.post('Power BI Streaming API', data=json.dumps(json_data))
print(res.status_code)
schedule.every(10).seconds.do(my_func)
while True:
schedule.run_pending()
time.sleep(5)
Thanks in Advance
3 Replies
- v-chenwuz-msftCommunity Support
Hi Anonymous ,
Did you miss some commas in the json_data list?
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
No commas are there. I forgot to add it here. but still it's not working
- v-chenwuz-msftCommunity Support
Hi Anonymous ,
Please check the type of dict_qs['hour'], is it int and match the type you definded in power bi. If not, please change it via int().
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.