cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirvana_moksh Established Member
Established Member

Azure Log Analytics Error

Hello All,

 

With OMS being depreciated as of yesterday I was trying to grab logs/data from Log Analytics in Power BI. I know Log Analytics a PBI M script that you can input as a blank query. What I am trying to do is run it as a Data Flow so that this can be shared by other users as well and also leverage Data Flow, but I am getting an error everytime I connect and it says 'Connection cannot be created'.

 

Also, I was wondering if there is a way to extract all Log Analytics info and dump it to a Database like SQL and use that as a Power BI source?

 

Thank YouCapture.PNGError when trying to create DataFlow using Blank Query

2 REPLIES 2
Community Support Team
Community Support Team

Re: Azure Log Analytics Error

@nirvana_moksh,

 

Have you configured the credentials correctly? In dataset-> Data source credentials. Then click Edit credentials and specify credentials with access to Log Analytics.

 

Regards,

Jimmy Tao

nirvana_moksh Established Member
Established Member

Re: Azure Log Analytics Error

@v-yuta-msft - Finally got it to work, there is this Microsoft Account Management error that Microsoft's support confirmed that if a client has Kerberos Auth first and Forms Based Auth 2nd connection to different data sources using an elevated account will redirect to your personal still.

 

 

Anyways, that is another issue, what I am still facing is that the Log Analytics query only returns 10k records and if I copy paste the query from Log Analytics with a custom time range of 1 year it again gives me 'Query has errors' error in data flows. Is this normal?

 

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 365 members 3,790 guests
Please welcome our newest community members: