Same config

[Anonymous]

Hi, my problem is that I combine SQL with some data from a sheet of google drive. 

I use the same file for several workspaces, same config, same open link, everything is the same, the gateways are in other servers but they also have the same config. When I refresh, just one of the workspaces/report allow me to do it, the other ones send this errors and I dont know why. 

[nickyvv · Accepted solution]

Thanks @Anonymous, that helps! 😀

After searching I ended up at another question on the forum, which explains the same error (Cannot load file or assembly 'CefSharp.Core.dll'), although with installing PBI Desktop, and resolves it by upgrading from Windows 8 to W8.1.

So I think the problem is, because you are refreshing in the service, the Gateway server you are using is running on Windows 8. You might wanna try upgrading that to Windows 8.1 and make sure the latest version of the Gateway is also running and then try refreshing again!

[Anonymous]

Thank you again @nickyvv , it was installed on several servers, but the answer gave me an idea of what could it be, because I tried it on newer servers and it worked perfectly. So I asked the clients to upgrade the .NET framework, and the gateway, hoping that fixes it

[nickyvv]

Hi @Anonymous,

could you please provide the English translation of that error message please?

That will save us a lot of time trying to type that into a translator.. 🙂 

[Anonymous]

Oh, you are right, sorry. I don´t paste the image, because, even if I change my explorers language, the message is in spanish, but this is the translate:


"Last refresh failed: Tue Feb 02 2021 16:09:21 GMT-0600 (Central Standard Time)
Unable to connect to the data source undefined.Hide details
Underlying error code: -2147467259
Underlying error message: We have not been able to retrieve the content of "https://docs.google.com/spreadsheets/d/e/2PACX-1vT2LCIYxQD1ZdMSKBP36jflDJwRKXMjKPJy9kawOdMQ8coWx4ceJ...".
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: Exit Code: 255 Standard Output: Standard Error: Unhandled Exception: System.IO.FileNotFoundException: Cannot load file or assembly 'CefSharp.Core.dll' or one of its dependencies. Cannot find the specified module. in Microsoft.Mashup.CefHelper.Program.Main (String [] args)
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-PAAS-1-SCUS-redirect.analysis.windows.net
Activity ID: 67b972cc-5e63-41d9-9527-41729fda31dc
Request ID: 56bcc0cf-4d90-c4b1-8a3e-a0697ce703ba
Time: 2021-02-02 22: 09: 21Z"

Every configuration is the same, from gateway and desktop to power bi service. 

Regards