Jun 26 2020 05:34 AM
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
Jul 02 2020 12:16 AM
Any recommendations?!
Aug 01 2021 11:55 AM
I have same issue @etsik
May 19 2022 02:39 AM
I experience the same issue, however when I open the workbook with the "Open in Desktop App" function, I can refresh pivots?
1st prize will be to be able to refresh when viewing the workbook in the 'Browser'.
May 19 2022 03:28 AM
So far refresh on web works only with sources within file or anonymous Odata.
However, in any case, even if works, if you use local database or other source On-premises data gateway - Power BI | Microsoft Docs shall be installed to work with such sources from cloud.