Forum Discussion
examples in PowerShell / C# handle the dataset (search a record in data set, then update or delete)
In streaming data set, I had the add record examples only
Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))
I want to get the example in clear the dataset (not delete)
search a record in the dataset, then either update or delete.
do anyone know where to find the examples ?
Hi Anonymous,
The use case for streaming datasets is for the display of transient data and should be regarded as volatile, even if you're using a push dataset with history enabled. They are not as fully featured as regular datasets and don't support filtering. As such there's only API methods to push data or clear the dataset. They're not a good substitute for a transactional database.
Power BI is not for the storage of data but for its aggregation and analysis, so if you want to set up something like what you're asking, this is beyond the features on offer for push/streaming datasets and you would be better looking to either:
- (if you have Premium) Create a dataset that live-connects to your report, and then use the XMLA endpoint methods to read or write data. However, this is still an analytical model and probably still a sub-optimal choice for persisting transactional data.
- Implement your own middleware with a transactional database for persistence and manage read/write methods using suitable technologies.
- Again, you'd want a data source that could support live-connect if you want something low latency
- Then build a Power BI dataset that reads from this for your report.
- If looking for a low-code solution, for example, you could manage this with CDS and Power Automate (if you're not familiar with the roles each part of Power Platform plays then this article does a good job of explaining that also).
- As CDS is a premium connector for Power Automate, this simplicity would come at a cost, however, if you're not already paying for Power Apps licensing.
Probably not the answer you were looking for but hopefully clarifies where you're currently stuck and will hopefully allow you to approach the challenge in a different way.
Good luck!
Daniel
2 Replies
- dm-p
Super User
Hi Anonymous,
The use case for streaming datasets is for the display of transient data and should be regarded as volatile, even if you're using a push dataset with history enabled. They are not as fully featured as regular datasets and don't support filtering. As such there's only API methods to push data or clear the dataset. They're not a good substitute for a transactional database.
Power BI is not for the storage of data but for its aggregation and analysis, so if you want to set up something like what you're asking, this is beyond the features on offer for push/streaming datasets and you would be better looking to either:
- (if you have Premium) Create a dataset that live-connects to your report, and then use the XMLA endpoint methods to read or write data. However, this is still an analytical model and probably still a sub-optimal choice for persisting transactional data.
- Implement your own middleware with a transactional database for persistence and manage read/write methods using suitable technologies.
- Again, you'd want a data source that could support live-connect if you want something low latency
- Then build a Power BI dataset that reads from this for your report.
- If looking for a low-code solution, for example, you could manage this with CDS and Power Automate (if you're not familiar with the roles each part of Power Platform plays then this article does a good job of explaining that also).
- As CDS is a premium connector for Power Automate, this simplicity would come at a cost, however, if you're not already paying for Power Apps licensing.
Probably not the answer you were looking for but hopefully clarifies where you're currently stuck and will hopefully allow you to approach the challenge in a different way.
Good luck!
Daniel