web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

MS Fabric: Connection to F&O data get "Unexpected Error"

(0) ShareShare
ReportReport
Posted on by 515
Hi guys,
 
I am integrating data from F&O to my Lakehouse in Fabric. I created a new data pipeline and follow steps to get connection to F&O using Azure Connectors  via App ID.
All data (tenant ID, Client ID) are created and input, but I get error (as below) when select Next step to connect to F&O data source. 
 
Could you please advise if my URL is correct?
 
 
 
API Permission to my App ID and a new Client ID is added in F&O environment
 
 
I wonder if the connection error happened because I don't have Azure subscription or PowerBI Premium license?
Because I could not create Fabric lakehouse and access data from Fabric workspaces via Azure Synapse link at Power Platform admin page, then I have to use Azure Connecter as above mentioned, but I got error in both approaches. 
 
 
 
I am looking forward to seeing your advise. 
Many thanks
Ett
Categories:
I have the same question (0)
  • Suggested answer
    Sagar121 Profile Picture
    250 on at
    MS Fabric: Connection to F&O data get "Unexpected Error"
    I see in your last screenshot you are in Free Trial environment . Can you switch back to actual D365 Sandox environment ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans