cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RickMcFish
Regular Visitor

Dataflow no longer showing SQL tables when creating or amending a dataflow

I have been using dataflows to populate tables in Dataverse from our on premises SQL Server, connecting via a data gateway. This has been working fine for days, yet today (Friday 11th Feb) it no longer returns any tables at all. 

 

I have double checked the credentials used and the data gateway and both seem to be operating OK. I can use the same data gateway/credentials to access the SQL DB in Power Automate and when building an app in Power Apps, but as soon as I come to build a data flow in Power Apps to populate a Dataverse table I get nothing returned.

RickMcFish_0-1644599624195.png

In short, this worked fine yesterday. Does not today. Nothing, to my knowledge has changed, and the gateway/credentials used works as expected in other M365 services.

 

Any ideas? 🙂 

1 REPLY 1
RickMcFish
Regular Visitor

Hi all, thought I'd update anyone who is interested...

 

Turns out the problem was with the on-prem data gateway. We had an older version installed (June 2020 I believe). I upgraded the on-prem gateway to the latest, and now it all works again as expected.

 

Bit bizarre as to why only one specific thing would stop working and everything else (PBI, connecting via Power Automate etc) worked fine. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,262)