Home

Cannot Release Lock on SharePoint Online File

%3CLINGO-SUB%20id%3D%22lingo-sub-354478%22%20slang%3D%22en-US%22%3ECannot%20Release%20Lock%20on%20SharePoint%20Online%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354478%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20an%20xls%26nbsp%3Bhosted%20on%20SharePoint%20Online%20to%20pull%20data%20from%20a%20Analysis%20server%20cube%20hosted%20onPrem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20at%20On-Premise%20Data%20Gateway%20but%20not%20sure%20if%20that%20will%20work%3F%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20like%20this%20maybe%20possible%3F%20(Orange%20is%20existing%20infrastructure)%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20845px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F83886iB2D1F3A375136648%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-354478%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SSAS%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESSAS%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-356755%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20Release%20Lock%20on%20SharePoint%20Online%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356755%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20this%20might%20help.%20The%20Data%20Management%20Gateway%20can%20be%20used%20directly%20from%20Excel%2C%20so%20you%20might%20not%20need%20Azure%20SSAS.%20See%20scenario%202%20under%20the%20PowerBI%20section%20of%20this%20article.%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2F%2Fdn879362(v%3Dtechnet.10%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2F%2Fdn879362(v%3Dtechnet.10%3C%2FA%3E)%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi

How can I get an xls hosted on SharePoint Online to pull data from a Analysis server cube hosted onPrem?

 

Looking at On-Premise Data Gateway but not sure if that will work? 

Something like this maybe possible? (Orange is existing infrastructure)image.png

 

 

Thanks in advance.

1 Reply
Highlighted

I think this might help. The Data Management Gateway can be used directly from Excel, so you might not need Azure SSAS. See scenario 2 under the PowerBI section of this article.

https://docs.microsoft.com/en-us/previous-versions//dn879362(v=technet.10)