Trying simple dataflows Gen 2 API call saving to a table in a lake house. All good on the power query screen. Query runs fine and is successful but the storing to lake house fails. Shows a credential...
I did not switch accounts during any of this testing. I have removed all associted connections, tried updating gateway and re-establishing connections through that. No Luck. I have all the success in the world in Power Query. I can see all preview data in both tables and I can point to the lakehouse and see all the lakehouse selecitons, and log in just fine. All seems perfect. Then I publish and refresh. The tables work in the data flow as success but the saving to the lakehouse tables causes the break. It accepted my creds just fine right before publish? Im so confused..