Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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-msft's avatar
    v-chenwuz-msft
    Community 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

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

      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Community 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.