Common Data Services as a real-time source in Power BI?

[VFXPro]

Hello all,

I have a PBI real time data set, works like a charm, but Flow only allows to "Add to a dataset", and I need to update data.

I'm using CDS, which works really well for CRUD operations and shows up as a source in Power BI.

Is it possible to have CDS data display as a tile and refresh in real-time like PBI dataset does?

Is there a trick to "update" a record in PBI data set?

[Anonymous · Accepted solution]

HI @VFXPro,

According to your description, you want to update streaming dataset records right?

If this is a case, current streaming dataset api not cache data, so you can't operate previous pushed records.

Real-time streaming in Power BI

Given the previous question, how can I do any modeling on real-time datasets?

Modeling is not possible on a streaming dataset, since the data is not stored permanently. For a push dataset, you can use the update dataset/table REST APIs to add measures and relationships. You can get more information from the Update Table Schema article, and the Dataset properties article.

Regards,

Xiaoxin Sheng