Another hint at what the URL is that we are hitting that’s causing a problem is the Service URL that’s in the Power Query Registry key. Like the following:ĭataMashup.Trace Error: 24579 : įiddler can also show you some of the flow here, but not necessarily show you the problem with regards to the SSL piece. There can be a lot of data in this file, but we want to look for something that shows an Error. The trace location will be in your user folder under the following path:Ĭ:\Users\\AppData\Local\Microsoft\Power Query\Traces This is our first step to see what is actually happening.Ħ4 Bit machine with 32 bit Office ”TracingEnabled”=dword:00000001ģ2 Bit machine with 32 bit Office or 64 Bit machine with 64 bit Office ”TracingEnabled”=dword:00000001 This is enabled by way of a registry key. The Power Query Add-in has it’s own tracing mechanism. It was updated to include better information relating to the SSL/Certificate issues happening under the hoods. Please contact your IT administrator if this issue persists This could be an issue with your network connection, or the service may be unavailable.
Problem Signing In The service could not be contacted while signing in. The original error we got was the following: Please make sure that your client is up-to-date, and that no proxy between the client and the service is changing certificates. Problem Signing InA trust relationship with the service could not be established. The message now is actually worded a little more clear/helpful than it was at the time I first got the issue. What was happening is when trying to Sign In on the Power Query tab we would get an error.
By utilizing Power BI along with Power Automate and Power Apps, the company quickly created a travel approval, tracking, and reporting system.
Microsoft power bi sign in how to#
Through the course of troubleshooting that issue, I actually learned a bit about how the sign in process works with Power Query, so I thought I would share some of those findings along with how to identify some of this yourself. Toyota employs Power BI to drive confident decision-making through insights derived from their real-time data. I worked on a Power Query Sign in issue recently that took a different spin from what I would have expected.