Real time dash board with RestAPI/PBI Desktop

[Sreejith]

Hi,

I need to have a real time dash board where a refresh rate more than 3 seconds cannot be afforded. I tried REST Api to push data to a data set (created via REST Api) and is reflected on the dash board in no time. But there seems to be limitations in shaping the dataset created via REST Api when compared to modeling capabilities in PBI desktop like changing the type of the data etc.

1) Is it possible to model such a data set using the PBI Desktop after creation?

2) Is it possibe to model the data in same way as with PBI desktop application and achieve a real time refresh just like REST Api?

3) Can I push data to a data set created and published with PBI desktop?(To my best of knowledge this is not possible)

Any guidance appreciated.

[ashishrj · Accepted solution]

@Sreejith That's correct. You cannot work with data types as in Desktop tool. Also you cannot model your dataset in Power BI Desktop Tool and hence you cannot achieve real time data refreh using Power BI Desktop tool.

Find video given here for the webinar we have conducted on Power BI REST API. Demo is in 2nd half of the video. Hoep this will help !