Forum Discussion
Prompt to authenticate to some random SQL server? Consuming from DF Gen2.
I'm trying to test a client consuming from gen2 dataflows. This gen2 stuff still seem to have a lot of rough edges.
After using the PQ editor ('tranform' window), I click apply, and it starts importing the table from the gen2 dataflow. However, it doesn't last long, and all of a sudden I'm prompted to authenticate to some random SQL database. See image below.
Does anyone know what purpose this database is serving, and why I'm being asked to authenticate to it? This is not the most common of prompts, in my experience, and I think it is almost certainly a bug. Is there a way to consistently avoid this bug? Has anyone reported the bug to Microsoft? Is it one fo their "known issues"?
3 Replies
That's the infamous SQL Endpoint that comes with your lakehouse and warehouse destinations. During the write process Fabric insists to be able to read from that endpoint to somehow satiate its thirst for meta data (and failing if your company network is properly hardened)
I would concur with the "rough edges" statement.
What is the primary reason why it occurs? I'm pretty sure it is not intentional, right?
Are you saying a network glitch is causing it, or something like that?
Should we be contacting the network team in I.T., or is this a bug on the Microsoft side?
This here is the primary reason
What Microsoft conveniently ignore is that fact that this "solution" is being met with massive resistance from any reasonably knowledgeable internal IT department.
