Using Kusto functions in Power BI datasource
· 2 min read
References
- Use Azure Data Explorer data in Power BI
- .create function command
- Azure Data Explorer
- Kusto Query Language (KQL)
How to
Let's create demo data for testing
For the purpose of testing and demonstrating, I will create a new table in my testing ADX cluster (everyone can create their own free cluster following Create a free Azure Data Explorer cluster). Let's call it UserAsset
.
The table will have two fields:
User
- typestring
NumberOfLaptop
- typeinteger