DATAVERSE

[ARUNC12]

I have  atable created in Power apps and i wanted to bring it to my Power bi Desktop.however when i clicked Dataverse its showing the following error.

Can someone shed some light on What exactly is Dataverse and what are the things to remember for this kind of data,i am new to this.

[v-sgandrathi]

Hi @ARUNC12,

Thank you @Cookistador for the answer, the reply correctly mentions that port 5558 or 1433 needs to be open. 

Additionally, since you're new to Dataverse, here are some key points to remember:

Dataverse is a cloud-based data storage solution for Power Apps, Power BI, and Microsoft Dynamics 365. It provides a structured and secure way to store and manage data.

You can connect to Dataverse in Power BI using the Dataverse connector for a direct and seamless integration. If you prefer to use SQL queries, make sure that TDS (Tabular Data Stream) is enabled in the Dataverse settings to allow SQL-based access. Additionally, ensure that your user role has the necessary permissions to view and retrieve data from Dataverse, as access restrictions might prevent successful connections.

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

Regards,
Sahasra.

[v-sgandrathi]

Hi @ARUNC12,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @ARUNC12,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-sgandrathi · Accepted solution]

Hi @ARUNC12,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[Cookistador]

To avoid this erorr message, a port must be open

port:5558 or 1433

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query#blocked-por...