Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
When i try to use the dataverse connector to connect to datasource it does not give me the option to input my data source. This is what I see below. And when i try to input the datasource in the input box it does nothing. Is there a setting that is causing this?
Solved! Go to Solution.
Hi @wpf_ ,
In Power BI Desktop, when you connect to Dataverse with Dataverse connector, you just need sign in a account for connect the Dataverse, then in the list of environments, expand the environment you want, select the tables you want, and then select Load.
In Power BI Desktop, when you connect to Dataverse with Common data service connector, In the dialog box that appears, paste in your complete environment URL into the Server Url box, in the format https://org.crm.dynamics.com/. More information: Find your environment URL
For more details, you can read related document: Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @wpf_ ,
In Power BI Desktop, when you connect to Dataverse with Dataverse connector, you just need sign in a account for connect the Dataverse, then in the list of environments, expand the environment you want, select the tables you want, and then select Load.
In Power BI Desktop, when you connect to Dataverse with Common data service connector, In the dialog box that appears, paste in your complete environment URL into the Server Url box, in the format https://org.crm.dynamics.com/. More information: Find your environment URL
For more details, you can read related document: Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@wpf_ Not quite understanding this, for the Dataverse connector, the Dataverse IS the data source.
When i use sql server or cds(legacy) i have to input the environment name that im connecting to. It pops up with a window asking for it. But when I use dataverse connector it does not, it goes straight to the window i showed you. It's not asking for the environment name. And nothing shows up for me to chose anything.