Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I'm working on a dataflow that it is connected to dataverse. This connection is simple, but I don't know why I'm getting this error:
This is the power query code I'm using:
The strangest thing is that the dataflow refreshes with no issue, but when I enter on edit mode, it gives this error. I've tried to create a new dataflow with the same connection, and it works, but when I try to add transformations, it gives the same error.
Can someone help?
Hi @ribeirocr ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thanks and Regards
Hi @ribeirocr
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @ribeirocr,
Thanks for reaching out to the Microsoft fabric community forum.
Please try these troubleshooting steps and check if you are able to bypass the error
1) To use the Dataverse connector, the TDS endpoint setting must be enabled in your environment. For Reference: Manage feature settings - Power Platform | Microsoft Learn
2) To use the Dataverse connector, one of TCP ports 1433 or 5558 need to be open to connect. Port 1433 is used automatically. However, if port 1433 is blocked, you can use port 5558 instead. To enable port 5558, you must append that port number to the Dataverse environment URL, such as yourenvironmentid.crm.dynamics.com, 5558.
Power Query Dataverse connector - Power Query | Microsoft Learn
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to give "Kudos"
Thanks and Regards
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
28 | |
26 | |
22 | |
22 | |
18 |
User | Count |
---|---|
51 | |
34 | |
28 | |
24 | |
21 |