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.