Is it possible to fetch data from multiple Log analytics workspace from powerBI?

%3CLINGO-SUB%20id%3D%22lingo-sub-333575%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20fetch%20data%20from%20multiple%20Log%20analytics%20workspace%20from%20powerBI%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333575%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3ESince%20Log%20Analytics%20is%20not%20natively%20supported%20in%20powerBI%2C%20rest%20api%20from%20powerBI%20seems%20to%20be%20the%20way%2C%20like%20mentioned%20in%20this%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fpowerbi%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Edocumentation%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESince%20each%20rest%20API%20will%20be%20pointing%20to%20single%20LA%20with%20corresponding%20authtoken%2C%20I%20am%20wondering%26nbsp%3B%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3Eis%20it%20possible%20to%20query%20multiple%20LA%20workspace%3F%20Is%20there%20a%20way%20to%20achieve%20that%3F%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EThanks.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-333575%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-334070%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20fetch%20data%20from%20multiple%20Log%20analytics%20workspace%20from%20powerBI%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334070%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EYes%20this%20is%20possible.%20Each%20connection%20you%20make%20will%20have%20its%20own%20credentials.%20This%20scenarios%20is%20also%20mentioned%20in%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fservice-providers%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fservice-providers%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%22Power%20BI%20as%20a%20central%20location%3A%20Power%20BI%20can%20act%20as%20the%20central%20location%20when%20the%20various%20workspaces%20export%20data%20to%20it%20using%20the%20integration%20between%20Log%20Analytics%20and%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fpowerbi%22%20data-linktype%3D%22relative-path%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPower%20BI%3C%2FA%3E.%20%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Hello,

Since Log Analytics is not natively supported in powerBI, rest api from powerBI seems to be the way, like mentioned in this documentation

Since each rest API will be pointing to single LA with corresponding authtoken, I am wondering is it possible to query multiple LA workspace? Is there a way to achieve that?

Thanks.

1 Reply

Hi,

Yes this is possible. Each connection you make will have its own credentials. This scenarios is also mentioned in:

https://docs.microsoft.com/en-us/azure/azure-monitor/platform/service-providers

"Power BI as a central location: Power BI can act as the central location when the various workspaces export data to it using the integration between Log Analytics and Power BI. "