Forum Discussion
How to connect multiple Dataverse on a report
Hi EthanHu ,
Thank you for engaging with Microsoft Fabric Community.
To connect to another Dataverse environment using a different credential, you will need to clear the cached credentials for the existing Dataverse connection in Power BI Desktop. Please follow these steps:
-
In Power BI Desktop, go to File > Options and settings > Data source settings.
-
Find the existing Dataverse connection (typically the environment URL).
-
Select it and click Clear Permissions.
-
Close the dialog and use Get Data > Dataverse, and enter the full URL of the new environment in the Advanced options.
-
You will now be prompted to sign in again. Enter the credentials for the new Dataverse environment.
Repeat the above steps for each Dataverse instance you want to connect to.
For enabling scheduled refresh in Power BI Service after publishing the report:
-
Open the workspace where the dataset was published.
-
Select the dataset(semantic model), then click on Settings.
-
Under Data source credentials, update or enter the appropriate credentials for each Dataverse connection.
-
Scroll to the refresh section, turn it On, and configure the frequency and time.
-
Save the changes.
This will ensure each connection uses the correct credentials and that refresh occurs as scheduled.
Here are some helpful and similar resources:
Establishing multiple dataverse connections across... - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.Thank you.
-
Hi Akash_Varuna ,
Thank you for your reply. When I click to connect to Dataverse in Power Query, it will log in directly without me entering a new credential, How can I do?
May I ask how to enable scheduled refresh and if it's possible to capture some images so that I can easily locate the settings.
Community SupportHi EthanHu ,
Thank you for engaging with Microsoft Fabric Community.
To connect to another Dataverse environment using a different credential, you will need to clear the cached credentials for the existing Dataverse connection in Power BI Desktop. Please follow these steps:
-
In Power BI Desktop, go to File > Options and settings > Data source settings.
-
Find the existing Dataverse connection (typically the environment URL).
-
Select it and click Clear Permissions.
-
Close the dialog and use Get Data > Dataverse, and enter the full URL of the new environment in the Advanced options.
-
You will now be prompted to sign in again. Enter the credentials for the new Dataverse environment.
Repeat the above steps for each Dataverse instance you want to connect to.
For enabling scheduled refresh in Power BI Service after publishing the report:
-
Open the workspace where the dataset was published.
-
Select the dataset(semantic model), then click on Settings.
-
Under Data source credentials, update or enter the appropriate credentials for each Dataverse connection.
-
Scroll to the refresh section, turn it On, and configure the frequency and time.
-
Save the changes.
This will ensure each connection uses the correct credentials and that refresh occurs as scheduled.
Here are some helpful and similar resources:
Establishing multiple dataverse connections across... - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.
Thank you.