Need help on Streaming Dataset

[Anonymous]

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

[v-chenwuz-msft]

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.

[Anonymous]

No commas are there. I forgot to add it here. but still it's not working

[v-chenwuz-msft]

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.