Refresh Pivot Tables through MS Teams and/or Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-1491902%22%20slang%3D%22en-US%22%3ERefresh%20Pivot%20Tables%20through%20MS%20Teams%20and%2For%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491902%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EWe%20have%20an%20Excel%20file%20(opening%20locally)%20with%20several%20pivot%20tables%20getting%20data%20from%20a%20local%20SQL%20server%2C%20which%20is%20working%20fine.%3C%2FP%3E%3CP%3EWhen%20we%20try%20to%20upload%20it%20to%20Teams%20or%20Excel%20online%2C%20refresh%20stops%20working.%20Prompts%20for%20wrong%20credentials%20(which%20is%20not%20true)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20we%20somehow%20make%20this%20work%20thru%20Teams%20or%20Excel%20online%3F%3C%2FP%3E%3CP%3EMigration%20to%20PBI%2C%20is%20not%20an%20option%20right%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1491902%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hello,

We have an Excel file (opening locally) with several pivot tables getting data from a local SQL server, which is working fine.

When we try to upload it to Teams or Excel online, refresh stops working. Prompts for wrong credentials (which is not true)

 

Can we somehow make this work thru Teams or Excel online?

Migration to PBI, is not an option right now.

 

Many thanks

1 Reply
Highlighted