Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am building a report on Power BI service using the historical streaming dataset (hybrid), which uses PowerShell to retrieve the data from SQL server and upload to Power BI using the endpoint link provided. However, after each refresh, I only want to capture a certain amount of data and delete the old one (I don't want the dataset to be accumulated). Is there any way (specifically using PowerShell, but other tools should be fine) that I can refresh the hybrid streaming dataset programmatically, or delete the whole dataset and refresh with a new one? Thanks in advance!
Hi @evienguyen,
when you have a streaming dataset set to Hybrid this means the switch at Historic data analysis is set to On.
If I want to clear my dataset I usually switch it to off, save it and edit it again and switch it back on. This way the data in the streaming dataset get's cleared and you start with a fresh (empty) dataset.
I don't know how to set this in PowerShell, but I assume you can do this also programattically.