Hi, does anybody knows if this is already possible?
i have a file on my desktop which refreshes fine, but once moved online (Teams/Excel Online) give an error when trying to refresh
for example:
"Connection: Query - DB
Error: COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location=DB;extended properties="UEsDBBQAAgAIAJV4VlSGY5w/pwAAAPgAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPvQ6CMBhFX4V0p38qUfNRBicTSExMjCspFRqhGFos7+bgI/kKkijq5nhPznDu43aHZGjq4Ko6q1sTI4YpCpSRbaFNGaPencIlSgTscnnOSxWMsrHrwRYxqpy7rAnx3mM/w21XEk4pI8cs3ctKNTn6yPq/HGpjXW6kQgIOrxjBccTwgq04nkcMyIQh0+ar8LEYUyA/EDZ97fpOiUqF2xTINIG8X4gnUEsDBBQAAgAIAJV4VlQPyumrpAAAAOkAAAATABwAW0NvbnRlbnRfVHlwZXNdLnhtbCCiGAAooBQAAAAAAAAAAAAAAAAAAAAAAAAAAABtjksOwjAMRK8SeZ+6sEAINWUB3IALRMH9iOajxkXhbCw4ElcgbXeIpWfmeebzelfHZAfxoDH23inYFCUIcsbfetcqmLiRezjW1fUZKIocdVFBxxwOiNF0ZHUsfCCXncaPVnM+xxaDNnfdEm7LcofGOybHkucfUFdnavQ0sLikLK+1GQdxWnNzlQKmxLjI+JewP3kdwtAbzdnEJG2UdiFxGV5/AVBLAwQUAAIACAAqMlZUHlMA1moDAACzDwAAEwAcAEZvcm11bGFzL1NlY3Rpb24xLm0gohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAA5VZdT9swFH1H4j9Y4aWVvEpI014Yk6CFwQaDtd2HhFDkJrfFa2oj22FMVf8DSGMITULbNE3AH8rf2XXTj6TJRpXtjVSFxMf3nnuPT1xr8AyXgjTi/8sriwuLC/qIKfDJtmgrpo0KPRMqIKskALO4QPBqyFB5dmTj1IOgUg2VAmHeSdVtSdktlfsHr1gPVp10BudwcFCVwuDUw8UFLpK5kry7XHBWlHISPC/b3v7G+yJENm5ejq26W4OTIixx5Lw8bxpugwWgXSZ8t6mYX0jCbJZ5+WvruXxN1gqgUpW9FhdQ6mfz0xmv0akH6HCB6EjCQZnGuZecTR4YsKR1+VE7E5YGBGhlO1aK+SkB5h2R0sG+kh8Q0ofk6TMiwiAoT5NVj5joYK7mp2OY5sLahG5L1avKIOwJC+rSLDPt952GYcqQGjPgUGJwGvHxfkBJ39lTvMMFC8iG8PNnbJweY1mYDnCGnztDmwrZwm40GWMi7LVADdFdhs0QLMGEegwbODVDMB4mdWBaigyKS9LDNc2GbZNHdkmwdfCzUQiiG3SIMmTRNUTXPE+GwlgRM3gd8TroY0zA8/Am011SA+3lI0uONYt58rhil2M6/lzJ8DgTMl7zDICisY7t/Z5q1rTmHUGMJJOI1JyEIXdBWQu9DkFxSDjyFWjU6YXkojRjNJoocECXxg9kh2szA85gNttLLvzKDrTNXoh2nNaBfsIXCzlSIZNyYnh4H9u6lCmdkhm6oWBcjDPaCeshD3wuOqQVSK+bDGkcSXwZ7FbiDIpHlqf7zJ9aSu480Xn0LbrCz50b3UW3+MXbIptfbqLk/ldkzxjtRP2/GjKlUhrMSJbr8qR+aY8mtUyVnZLwGlv9Ev2ILqKbQsol4h+KYL+w2Ss0zEVBs6UyPAzRftoXCtu9dKPP2P9tdBadu/b+bKjCbXRVSMn70z44ea+jr/hwY63l4p/v0WV04/6ruLlJH4S0M7/P85x07xWOzvM+0Jmdhqa2apr/25dsKntQrzPRLeIEG/f/FntTyV7eibYpcwaH1LlHr7XQyDr05An4MY9exgpibNKhvcykMMv8lgUhZI5k5KAGbYZH2ziVbRujRo2X41xjXe0V54vpR+wlQydGGA7stW1uO9yPy7fgqBUFnlT+6CFAYw3KiZXLaW3lN1BLAQItABQAAgAIAJV4VlSGY5w/pwAAAPgAAAASAAAAAAAAAAAAAAAAAAAAAABDb25maWcvUGFja2FnZS54bWxQSwECLQAUAAIACACVeFZUD8rpq6QAAADpAAAAEwAAAAAAAAAAAAAAAADzAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQAAgAIACoyVlQeUwDWagMAALMPAAATAAAAAAAAAAAAAAAAAOQBAABGb3JtdWxhcy9TZWN0aW9uMS5tUEsFBgAAAAADAAMAwgAAAJsFAAAAAA==".
A connection could not be made to the data source with the DataSourceID of 'db5ba929-027e-4107-8a85-43b3c0bb8676', Name of '<pii>Query - DB</pii>'.
An error occurred while processing table '<pii>DB</pii>'.
COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location=Rank.
A connection could not be made to the data source with the DataSourceID of 'b21404d5-dcd0-4289-8d0b-e3fd088e3a32', Name of '<pii>Query - Rank</pii>'.
An error occurred while processing table '<pii>Rank</pii>'.
The current operation was cancelled because another operation in the transaction failed."
i have a file on my desktop which refreshes fine, but once moved online (Teams/Excel Online) give an error when trying to refresh
for example:
"Connection: Query - DB
Error: COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location=DB;extended properties="UEsDBBQAAgAIAJV4VlSGY5w/pwAAAPgAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPvQ6CMBhFX4V0p38qUfNRBicTSExMjCspFRqhGFos7+bgI/kKkijq5nhPznDu43aHZGjq4Ko6q1sTI4YpCpSRbaFNGaPencIlSgTscnnOSxWMsrHrwRYxqpy7rAnx3mM/w21XEk4pI8cs3ctKNTn6yPq/HGpjXW6kQgIOrxjBccTwgq04nkcMyIQh0+ar8LEYUyA/EDZ97fpOiUqF2xTINIG8X4gnUEsDBBQAAgAIAJV4VlQPyumrpAAAAOkAAAATABwAW0NvbnRlbnRfVHlwZXNdLnhtbCCiGAAooBQAAAAAAAAAAAAAAAAAAAAAAAAAAABtjksOwjAMRK8SeZ+6sEAINWUB3IALRMH9iOajxkXhbCw4ElcgbXeIpWfmeebzelfHZAfxoDH23inYFCUIcsbfetcqmLiRezjW1fUZKIocdVFBxxwOiNF0ZHUsfCCXncaPVnM+xxaDNnfdEm7LcofGOybHkucfUFdnavQ0sLikLK+1GQdxWnNzlQKmxLjI+JewP3kdwtAbzdnEJG2UdiFxGV5/AVBLAwQUAAIACAAqMlZUHlMA1moDAACzDwAAEwAcAEZvcm11bGFzL1NlY3Rpb24xLm0gohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAA5VZdT9swFH1H4j9Y4aWVvEpI014Yk6CFwQaDtd2HhFDkJrfFa2oj22FMVf8DSGMITULbNE3AH8rf2XXTj6TJRpXtjVSFxMf3nnuPT1xr8AyXgjTi/8sriwuLC/qIKfDJtmgrpo0KPRMqIKskALO4QPBqyFB5dmTj1IOgUg2VAmHeSdVtSdktlfsHr1gPVp10BudwcFCVwuDUw8UFLpK5kry7XHBWlHISPC/b3v7G+yJENm5ejq26W4OTIixx5Lw8bxpugwWgXSZ8t6mYX0jCbJZ5+WvruXxN1gqgUpW9FhdQ6mfz0xmv0akH6HCB6EjCQZnGuZecTR4YsKR1+VE7E5YGBGhlO1aK+SkB5h2R0sG+kh8Q0ofk6TMiwiAoT5NVj5joYK7mp2OY5sLahG5L1avKIOwJC+rSLDPt952GYcqQGjPgUGJwGvHxfkBJ39lTvMMFC8iG8PNnbJweY1mYDnCGnztDmwrZwm40GWMi7LVADdFdhs0QLMGEegwbODVDMB4mdWBaigyKS9LDNc2GbZNHdkmwdfCzUQiiG3SIMmTRNUTXPE+GwlgRM3gd8TroY0zA8/Am011SA+3lI0uONYt58rhil2M6/lzJ8DgTMl7zDICisY7t/Z5q1rTmHUGMJJOI1JyEIXdBWQu9DkFxSDjyFWjU6YXkojRjNJoocECXxg9kh2szA85gNttLLvzKDrTNXoh2nNaBfsIXCzlSIZNyYnh4H9u6lCmdkhm6oWBcjDPaCeshD3wuOqQVSK+bDGkcSXwZ7FbiDIpHlqf7zJ9aSu480Xn0LbrCz50b3UW3+MXbIptfbqLk/ldkzxjtRP2/GjKlUhrMSJbr8qR+aY8mtUyVnZLwGlv9Ev2ILqKbQsol4h+KYL+w2Ss0zEVBs6UyPAzRftoXCtu9dKPP2P9tdBadu/b+bKjCbXRVSMn70z44ea+jr/hwY63l4p/v0WV04/6ruLlJH4S0M7/P85x07xWOzvM+0Jmdhqa2apr/25dsKntQrzPRLeIEG/f/FntTyV7eibYpcwaH1LlHr7XQyDr05An4MY9exgpibNKhvcykMMv8lgUhZI5k5KAGbYZH2ziVbRujRo2X41xjXe0V54vpR+wlQydGGA7stW1uO9yPy7fgqBUFnlT+6CFAYw3KiZXLaW3lN1BLAQItABQAAgAIAJV4VlSGY5w/pwAAAPgAAAASAAAAAAAAAAAAAAAAAAAAAABDb25maWcvUGFja2FnZS54bWxQSwECLQAUAAIACACVeFZUD8rpq6QAAADpAAAAEwAAAAAAAAAAAAAAAADzAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQAAgAIACoyVlQeUwDWagMAALMPAAATAAAAAAAAAAAAAAAAAOQBAABGb3JtdWxhcy9TZWN0aW9uMS5tUEsFBgAAAAADAAMAwgAAAJsFAAAAAA==".
A connection could not be made to the data source with the DataSourceID of 'db5ba929-027e-4107-8a85-43b3c0bb8676', Name of '<pii>Query - DB</pii>'.
An error occurred while processing table '<pii>DB</pii>'.
COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location=Rank.
A connection could not be made to the data source with the DataSourceID of 'b21404d5-dcd0-4289-8d0b-e3fd088e3a32', Name of '<pii>Query - Rank</pii>'.
An error occurred while processing table '<pii>Rank</pii>'.
The current operation was cancelled because another operation in the transaction failed."
