Antonio De Sousa Campos on 06 Jan 2023 14:29:00
It is unable to refresh a dataset based on Azure Log Analytics workspace, using Web.Contents function, since the query is a dynamic data source, built with KQL. It would be extremely helpful if it becomes possible.
As a workaround, the dataset can be refreshed if I work with blob storage as the data source, instead of Log Analytics as the destination of a 'diagnostic setting', but I don't have any way to apply transformation rules on 'blob storage' diagnostic setting and the amount of data got from there is extremely massive and the report takes too much time to refresh.
Thank you.
- Comments (1)
RE: Refresh Azure Log Analytics data source in Power BI service
Hi Antonio, thanks for reporting this. We will take a look. In the meanwhile, if you use a KQL database in Fabric, and run the query this way: PBI->KQLDB-> LA workspace, this will work for you.