Home

Refresh for Azure Analysis Services in Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-160521%22%20slang%3D%22en-US%22%3ERefresh%20for%20Azure%20Analysis%20Services%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-160521%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20been%20trying%20for%20months%20unsuccessfully%20to%20get%20a%20refresh%20working%20on%20an%20Azure%20SSAS%20Tabular%20source%20in%20Excel%20online.%20This%20works%20fine%20in%20desktop%20but%20fails%20in%20excel%20online%20with%20the%20message%20attached.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20s%20a%20very%20important%20functionality%20for%20our%20clients.%20Anyone%20if%20this%20is%20possible%20and%20how%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMartin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-160521%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-656971%22%20slang%3D%22en-US%22%3ERe%3A%20Refresh%20for%20Azure%20Analysis%20Services%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656971%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F97073%22%20target%3D%22_blank%22%3E%40Martin%20K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20solve%20that%3F%3C%2FP%3E%3CP%3EI%20have%20a%20similar%20problem%20-%20what%20I%20intend%20to%20do%20is...%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E1.%20Connect%20Excel%20to%20SSAS-Tabular%20(OnPrem)%20%26amp%3B%20Create%20Pivot%20Report%20%3CSTRONG%3E(OK)%3C%2FSTRONG%3E%3CBR%20%2F%3E2.%20Publish%20to%20PBI%20Service%20(File%20-%26gt%3B%20Publish%20-%26gt%3B%20Workspace)%20%3CSTRONG%3E(OK)%3C%2FSTRONG%3E%3CBR%20%2F%3E3.%20Use%20of%20the%20Excel%20report%20within%20Power%20BI%20Service%20with%20a%20live%20connection%20(including%20RLS)%20via%20gateway.%20%3CSTRONG%3E(FAILED)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithin%20Power%20BI%20that's%20actually%20Excel%20Online%20(O365)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20that%20does%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Fpbs.twimg.com%2Fmedia%2FD7wwlXrXYAAi56z.png%22%20border%3D%220%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Martin K
Occasional Visitor

We have been trying for months unsuccessfully to get a refresh working on an Azure SSAS Tabular source in Excel online. This works fine in desktop but fails in excel online with the message attached.

 

This is s a very important functionality for our clients. Anyone if this is possible and how?

 

Thanks!

 

Martin

1 Reply

@Martin K 

 

Could you solve that?

I have a similar problem - what I intend to do is...


1. Connect Excel to SSAS-Tabular (OnPrem) & Create Pivot Report (OK)
2. Publish to PBI Service (File -> Publish -> Workspace) (OK)
3. Use of the Excel report within Power BI Service with a live connection (including RLS) via gateway. (FAILED)

 

Within Power BI that's actually Excel Online (O365) 

 

And that does not work.

 

Any idea?

 

Related Conversations