Missing Connection Details

Hi billie90 ,

Thank you for engaging with the Microsoft Fabric Community.  Power BI Desktop uses your local credentials, which is why the report works there. However, once the report is published to Power BI Service, the dataset needs a proper data connection with valid credentials.

To resolve the issue, follow these steps.

1.Navigate to the workspace where the report is published.
2. Find the dataset (not just the report), click the ellipsis (...), and select Settings.
3. Scroll to the Data source credentials section.

4. Click Edit credentials. Choose OAuth2 as the authentication method.

5. Sign in with the Microsoft account that has access to the Dataverse environment.

6. After saving, manually refresh the dataset to verify it works.

Note: If your Dataverse environment URL is stored as a parameter in Power BI, ensure it has a valid default value and matches the live environment URL exactly.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.