Unable to load data from excel

[dharani-oss]

 I am trying to load data from excel but i am getting error message.

[skygold16 · Accepted solution]

Hi, 

I would suggest to re-install Power BI and try again. 

Thanks,

[v-pnaroju-msft · Accepted solution]

Thankyou, @skygold16, for your response.

Hi @dharani-oss,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

In addition to the response provided by @skygold16 ,kindly follow the steps mentioned below, which may help resolve the issue:

1. Ensure that the Excel file is in a supported format (.xlsx or .xls). Open the file in Excel and save it again to confirm that it is not corrupted.
2. Refresh the data source settings in Power BI. Navigate to File > Options and Settings > Data Source Settings. Locate the Excel data source, click on Clear Permissions, and then re-add the data source.
3. Repair the Microsoft Office installation. Go to Control Panel > Programs > Programs and Features. Locate Microsoft Office in the list, right-click on it, and select Change. Choose Repair and follow the on-screen instructions.
4. Run Power BI as an administrator. Right-click on the Power BI icon and select Run as Administrator. Try loading the data again. Additionally, ensure that you are using the latest version of Power BI.

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

Thank you.

[v-pnaroju-msft]

Hi dharani-oss,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi dharani-oss,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[andrewsommer · Accepted solution]

This is most likely due to either running an old version of Power BI or you are missing access database components.  You can try reinstalling Power BI or try installing the latest version of Microsoft.ACE.OLEDB. 

Please mark this post as solution if it helps you. Appreciate Kudos.

[v-pnaroju-msft]

Hi dharani-oss,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @skygold16, for your response.

Hi @dharani-oss,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

In addition to the response provided by @skygold16 ,kindly follow the steps mentioned below, which may help resolve the issue:

1. Ensure that the Excel file is in a supported format (.xlsx or .xls). Open the file in Excel and save it again to confirm that it is not corrupted.
2. Refresh the data source settings in Power BI. Navigate to File > Options and Settings > Data Source Settings. Locate the Excel data source, click on Clear Permissions, and then re-add the data source.
3. Repair the Microsoft Office installation. Go to Control Panel > Programs > Programs and Features. Locate Microsoft Office in the list, right-click on it, and select Change. Choose Repair and follow the on-screen instructions.
4. Run Power BI as an administrator. Right-click on the Power BI icon and select Run as Administrator. Try loading the data again. Additionally, ensure that you are using the latest version of Power BI.

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

Thank you.

[skygold16 · Accepted solution]

Hi, 

I would suggest to re-install Power BI and try again. 

Thanks,