Over the weekend one of our Powerapps appliactions stopped working we are running Power apps SQL connector through a on premises gateway to SQL Server 2012, the gateway seem to be fine the PowerBI reports runlike nothing has changed.
When we go to the powerapps web application and test the connection we get an error
"Credentials are missing or not valid. inner exception: Credentials are required to connect to the SQL source."
but the it was working 5 days ago
The Gateway log says
Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupCredentialException (0x80004005): Credentials are required to connect to the SQL source.
We are using the correct login details into the connector it is like it is not passing them on the the server when trying to connect?
Anyone had this issue or know where to start looking
Solved! Go to Solution.
If you were seeing this issue : "Invalid Mashup Expression using supplied values. inner exception: An error happened while reading data from the provider: 'Instance failure.'" - we have deployed a fix for this and things should be working now.
Can folks check and let us know if they are still seeing the issue?
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT