topic Need help on Streaming Dataset in Developer

Need help on Streaming Dataset

Anonymous — Mon, 25 Jul 2022 11:45:10 GMT

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

Re: Need help on Streaming Dataset

v-chenwuz-msft — Thu, 28 Jul 2022 07:12:03 GMT

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.

Re: Need help on Streaming Dataset

Anonymous — Thu, 28 Jul 2022 10:50:24 GMT

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

Re: Need help on Streaming Dataset

v-chenwuz-msft — Fri, 29 Jul 2022 05:46:12 GMT

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.