Hi @abir_mtar1234 ,
You may try create a streaming dataset in Power BI Service from SQL by following steps：
1.Navigate to your Power BI Service workspace, click on “+ Create” and then select "Streaming dataset".
2.In the “New streaming dataset” window, select the “API” tile, and then click "Next".
3.Give your dataset a name, add the necessary columns, and check “Historic data analysis” to enable data history and the ability to create reports. This option also allows you to create a tile in a dashboard.
4.After entering all the necessary details, click on "Create".
5.For streaming datasets you create in the Power BI service UI, the dataset owner gets a URL that includes a resource key. This key authorizes the requestor to push data into the dataset without using an Azure AD OAuth bearer token.
6.You can then use this URL to push data from your SQL server into the Power BI dataset.
Remember, a streaming dataset pushes data into the Power BI service, but Power BI only stores the data into a temporary cache, which quickly expires. The temporary cache is used only to display visuals that have some transient history.
Real-time streaming in Power BI - Power BI | Microsoft Learn
Push data into a Power BI dataset from SQL Server | ZappySys Blog
Best regards.
Community Support Team_Caitlyn
