Azure Synapse Link Connection issue through Power Apps

[ldtechgeek]

Hi Community, 

I have been seeing this issue since friday where I am not able to connect to my Azure Synapse Link through Power Apps. 

It is stuck at the loading icon for hours. I have a successful Synapse Link connection to F&O and migrated several tables into the data lake. This started when I tried adding more tables into the Data Lake. I see the new tables in the Data Lake and I am able to retrieve data from Synapse Workspace for the new tables I added. 

However, from Power Apps, this page is stuck with the loading icon. 

Any help will be apppreciated. Thanks in Advance. 

[v-veshwara-msft]

Hi @ldtechgeek ,
Thank you for sharing your experience.
If you find any of the helpful replies relevant to your situation, kindly mark them as solutions. This will help others who may encounter similar challenges benefit from the shared information.

Regards,
Vinay Kumar.

[ldtechgeek · Accepted solution]

Hi all, 
I seemed to have figured it out, I think. 
The good ol' caching issue. I cleared by browser cache, cookies and all the browsing data - closed out of edge and reopened it. I reauthenticated myself to Power Apps and now I am able to open Azure Synapse link and I see all the tables I added. 
Hopefully, y'all can try the same and see if it works. Thanks!

[v-veshwara-msft]

Hi @ldtechgeek ,

Thank you for reaching out and sharing your experience regarding the issue with Azure Synapse Link in Power Apps.

Glad to hear that clearing your browser cache, cookies, and browsing data, as well as reauthenticating yourself to Power Apps, resolved the issue. Caching issues can indeed be tricky, but it's great to know that this solution worked for you.

We appreciate you sharing your troubleshooting steps with us. This can be very helpful for other users who might encounter similar issues.

If you have any further questions or face any other challenges, please don't hesitate to reach out. 

Please mark the helpful reply as solution to help others find it more quickly.

Best Regards.

[stevehfin]

It's worth noting that Microsoft had to revert some "faulty code" (as support put it) before clearing browser cache and reauthenticating would work. This was a bug, not a caching issue, and should be acknowledged as such.

[v-veshwara-msft]

Hi @stevehfin ,
Thank you for clarifying that the issue was related to a bug, as verified by Microsoft support. While clearing cache can sometimes be effective in similar situations, it’s helpful to understand that the bug was the main factor here. I appreciate you sharing this update.
If you have any further questions or need assistance in the future, feel free to reach out!

[Gianluca_Colett]

I agree, it came back to work for me without doing any cache clearing or anything like that. It was just a bug

[Gianluca_Colett]

Small update from me: everything is back to working for me now, I no longer have loading problems stuck in displaying tables (nothing needed to be done)

[stevehfin]

As a heads up to anyone facing similar, I re-added 160 of the tables I'd lost yesterday afternoon and this morning they were all gone again. So be wary of the messaging from support.

[mbilal]

kudos! worked for me 

[stevehfin]

No luck for me unfortnately. Still missing almost all the tables I selected a few days back.

[stevehfin]

I can get the page loaded in edge (not chrome though) but it's saying I've got zero F&O tables selected (was ~117 on Friday after it 'forgot' one third of those I'd checked to be pulled...) so it's not really a solution. Dataverse down from over 400 to just 109.

[Gianluca_Colett]

Hello,
Same situation for me, trying to open Synapse Link from Power Apps loads me endlessly in any environment (tried on 3 different ones).

I also tried in private mode browser (unlike normal mode I could see the links but clicking on them still doesn't open the tables) but same problem, loading endlessly

Let me know if you can solve it!

[stevehfin]

Same - completely blocking development activities here 🙃

[mbilal]

into the same situation for last two hours.