Data Refresh from Excel Fails

Thank you suparnababu8 for your response.

Hi royce4,

We sincerely appreciate your inquiry through the Microsoft Fabric Community Forum.

Kindly refer to the solutions outlined below and check if they help resolve the issue:

1. Verify that the dataflows are properly configured in the Power BI service. Ensure that the dataflow refreshes are successful and that there are no connectivity issues with the underlying data sources.

2. Confirm that the user is properly signed into Power BI in Excel. Navigate to File > Account in Excel, and check whether the user is connected under Connected Services with the correct Power BI account. If not, please sign in again.

3. Attempt to refresh the data in Excel. If the refresh fails again, review the error message for further details.

4. Advise the user to access the report directly in Power BI instead of Excel to determine if the issue is specific to Excel.

5. Please note that admin access to workspaces does not automatically grant explicit access to semantic models. Navigate to the workspace, select the semantic model, go to Manage Permissions, and ensure the user has Read or higher access to the semantic model, even if they are a workspace administrator.

Additionally, you may refer to the following links for further guidance:
Troubleshoot the connection from Excel to Power BI data - Power BI | Microsoft Learn
Power BI semantic model experience in Excel - Power BI | Microsoft Learn

If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos, as this will assist other community members facing similar queries.

Thank you.