Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Connecting Log Analytics to Power BI with authorisation token

Hi there,   we are trying to load log analytics data into power bi.   We generated the query via export to Power BI in LogAnalytics and set the set notruncation option and a timeout of 59 minutes...
Need Help
Adamboer's avatar
Adamboer
Icon for Responsive Resident rankResponsive Resident
3 years ago

It sounds like you are facing issues with loading large amounts of data from Log Analytics into Power BI. One approach you could consider is using Azure Data Factory to move your Log Analytics data into Azure Blob Storage or Azure Data Lake Storage, and then use Power BI to connect to the storage account. This can help with data transformation and management before loading it into Power BI. Alternatively, you could explore using Azure Stream Analytics to stream the data into Power BI in near real-time. Both of these options require some additional setup and configuration, but can help with performance and scalability.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    So I've gotten a bit further with my research and it looks like we can change the named user in the Power BI Service to the service principal (this was the reason we needed a token). However this is one step ahead of what I want to do. Is there a way of implementing a token within the kusto query?