Unable to link an excel file to powerapps

Question

Unable to link an excel file to powerapps

Pruthviraj Hande 1 35

While following the instructions on the Training module : Describe how to build applications with Microsoft Power Apps

Following error message showed up.

Failed to read metadata from file source. Response from the end service is : Bad Request

clientRequestId: f092c24f-c1ec-497c-bf50-6bb025f7f771

serviceRequestId: f092c24f-c1ec-497c-bf50-6bb025f7f771;f092c24f-c1ec-497c-bf50-6bb025f7f771

Session ID: 4a2e8783-4a87-4f18-9398-256ada3f0770

Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-14T11:01:56.67+00:00

Hi PruthvirajHande1-9081,

Thank you for reaching out to us on the Microsoft Q&A forum.

Could you please specify the exact exercise link where you are encountering this error? Additionally, if possible, kindly provide a screenshot of the error for reference.
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-15T10:05:35.9666667+00:00

Hi PruthvirajHande1-9081,

Thank you for reaching out to us on the Microsoft Q&A forum.

Could you please specify the exact exercise link where you are encountering this error? Additionally, if possible, kindly provide a screenshot of the error for reference.
Pruthviraj Hande 1 35 Reputation points

2024-10-16T03:04:16.1133333+00:00

I was following the below instructions on "https://learn.microsoft.com/en-us/training/modules/introduction-power-apps/7-exercise-build-canvas-app":

Build a basic canvas app

Connect to a data source

To connect to a data source, use the following procedure:

Download the Contoso-Site-Tracking.zip file, extract all of the files, and save them to your OneDrive.

Go to https://make.powerapps.com and sign in with your organizational account.

In the left pane, select Create.

In the Start from data section, select Excel.

Under Connections, choose OneDrive. If you don't have the connection available, select New connection to create one.

For Choose an Excel file on the right select the Contoso Site Tracking.xlsx file.
Pruthviraj Hande 1 35 Reputation points

2024-10-16T03:04:55.2166667+00:00

On performing 6th step I was getting above error message.
Pruthviraj Hande 1 35 Reputation points

2024-10-16T03:06:43.14+00:00

I am using make.powerapps.com with my work email id but have connected personal one drive to it, where in I have saved the excel file that has to be used as source for making app.

Is that creating a problem ?
Pruthviraj Hande 1 35 Reputation points

2024-10-16T03:42:33.6633333+00:00

I tried with few other excel file other than specified in the make.powerapps.com site, still the same problem.

Accepted answer

1 additional answer

Your answer

Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-14T11:01:56.67+00:00

Hi PruthvirajHande1-9081,

Thank you for reaching out to us on the Microsoft Q&A forum.

Could you please specify the exact exercise link where you are encountering this error? Additionally, if possible, kindly provide a screenshot of the error for reference.
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-15T10:05:35.9666667+00:00

Hi PruthvirajHande1-9081,

Thank you for reaching out to us on the Microsoft Q&A forum.

Could you please specify the exact exercise link where you are encountering this error? Additionally, if possible, kindly provide a screenshot of the error for reference.
Pruthviraj Hande 1 35 Reputation points

2024-10-16T03:04:16.1133333+00:00

I was following the below instructions on "https://learn.microsoft.com/en-us/training/modules/introduction-power-apps/7-exercise-build-canvas-app":

Build a basic canvas app

Connect to a data source

To connect to a data source, use the following procedure:

Download the Contoso-Site-Tracking.zip file, extract all of the files, and save them to your OneDrive.

Go to https://make.powerapps.com and sign in with your organizational account.

In the left pane, select Create.

In the Start from data section, select Excel.

Under Connections, choose OneDrive. If you don't have the connection available, select New connection to create one.

For Choose an Excel file on the right select the Contoso Site Tracking.xlsx file.
Pruthviraj Hande 1 35 Reputation points

2024-10-16T03:04:55.2166667+00:00

On performing 6th step I was getting above error message.
Pruthviraj Hande 1 35 Reputation points

2024-10-16T03:06:43.14+00:00

I am using make.powerapps.com with my work email id but have connected personal one drive to it, where in I have saved the excel file that has to be used as source for making app.

Is that creating a problem ?
Pruthviraj Hande 1 35 Reputation points

2024-10-16T03:42:33.6633333+00:00

I tried with few other excel file other than specified in the make.powerapps.com site, still the same problem.

Answer 1

Syed Saleem Peera 13,060 Microsoft External Staff Volunteer Moderator

Hi PruthvirajHande1-9081,

Thank you for the additional details.

The issue you are facing likely stems from using a personal OneDrive with Power Apps, as it typically requires OneDrive for Business to connect properly with work accounts. I recommend saving the Contoso Site Tracking.xlsx file to your OneDrive for Business associated with your work email and trying the connection again.

Please let me know if you continue facing issues, and feel free to share a screenshot if the error persists.

If the information is helpful, please Accept Answer and Upvote so that it would be helpful to community members.

Thank you.

Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-17T10:25:18.0933333+00:00

Hi PruthvirajHande1-9081,

Just checking in to see if you had a chance to see my previous answer. Please let me know if it was helpful and don't hesitate to reach out to us if you face any issue.

If the information is helpful, please Accept Answer and Upvote so that it would be helpful to community members.

Thank you.
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-18T04:20:50.33+00:00

Hi PruthvirajHande1-9081,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-18T12:00:33.7733333+00:00

Hi PruthvirajHande1-9081,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.
Pruthviraj Hande 1 35 Reputation points

2024-10-18T17:23:25.2066667+00:00

Hi @Syed Saleem Peera ,

I could not apply the solution we discussed, yet.

Nextly,

I came across few more facts

a) I am having an account of power-apps, Power Automate (Desktop), Power Pages, Power BI (Desktop), - with my Business ID

b) MS 365 (free version and not a business version) & One drive associated with MS 365 - ID with my personal Outlook Account.

c) It is not defined anywhere that one need to use the onedrive of business ID only.

Is the solution discussed by us still valid ?

If yes, I will have to purchase onedrive for business and then test / check the solution.

I am hesitating because, if solution is not correct then I money will be wasted as I do not use onedrive much.
Tony 5 Reputation points

2024-10-18T17:26:47.4566667+00:00
Linking an Excel file to PowerApps can sometimes present challenges. Here are some troubleshooting steps and solutions to help you resolve the issue:

Check File Format and Location

File Format: Ensure your Excel file is in the correct format (.xlsx) and does not have macros.

Location: Make sure the Excel file is stored in a supported cloud service, such as OneDrive for Business or SharePoint Online. PowerApps does not support Excel files stored on local drives.

Set Up Excel Table

Create a Table: Ensure that your data in Excel is formatted as a table. Select your data range and go to Insert > Table in Excel.

Name the Table: Give the table a meaningful name. PowerApps requires a table to connect to.

Use the Correct Connector

PowerApps Connectors: Ensure you are using the Excel Online (Business) or Excel Online (OneDrive) connector in PowerApps. You can do this by:

In PowerApps, go to Data > Connectors and select the correct Excel connector.

Permissions

Check Permissions: Make sure that you have the appropriate permissions to access the Excel file. You must have at least read access to the file in OneDrive or SharePoint.

Create the Connection

Create a New Connection:

In PowerApps, go to Data > Connections.

Click on New connection, then select Excel Online (Business) or Excel Online (OneDrive).

Navigate to your file and select the appropriate table.

Refresh Data

Refresh Connection: Sometimes, the connection can become stale. You can refresh the data source in PowerApps:

Go to the Data tab and click on the ellipsis (...) next to your data source, then select Refresh.

Error Messages

Check Error Messages: If you receive specific error messages, they can provide clues about what is wrong. Search for the error message online or refer to the PowerApps documentation.

Use Power Query

If the Excel file has complex data transformations, consider using Power Query in Power BI to transform your data and then link the resulting data model to PowerApps.

Test with a Simple File

Simplify Testing: If you're still having trouble, try creating a simple Excel file with basic data and follow the steps to link it to PowerApps. This can help identify if the issue is with the specific file you are trying to use.

Check for Updates

Software Updates: Ensure that PowerApps and your web browser are up to date to avoid any compatibility issues.

If you have tried all these steps and are still unable to link the Excel file to PowerApps, consider reaching out to the Microsoft PowerApps support community or checking the official documentation for more guidance.
Pruthviraj Hande 1 35 Reputation points

2024-10-20T16:06:42.7066667+00:00

Hi @Syed Saleem Peera ,

Thanks for putting efforts to solve my problem well as doing follow-up.
Pruthviraj Hande 1 35 Reputation points

2024-10-20T16:15:51.1766667+00:00

@Tony

Dear Tony,

Thanks for your detailed instruction.

It seems I am violating two items in requirements you have specified.

a) I have not ensured that that file extension is .xlsx & it is not having any macros.

b) File is in my personal OneDrive (received along with my laptop along with "MS Windows - Student & Home Edition" and not in Business OneDrive or a Share point any one (but on cloud).

Let me do the needful in few days and get back.

@ Tony I will surely revert back to you and @Syed Saleem Peera about the status.Till then thank you.

@Pruthviraj Hande 1
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-21T06:28:22.11+00:00

Hi PruthvirajHande1-9081,

Thank you for your patience.

To help you test the solution without any upfront cost, you can sign up for a 30-day free trial of OneDrive for Business using your work email. This will allow you to confirm if linking the Excel file in Power Apps works as expected before making any financial commitment.

You can access the free trial here: OneDrive for Business 30-day free trial

Additionally, if OneDrive for Business is not a long-term solution for you, other cloud storage services like SharePoint also integrate well with Power Apps.

Let me know if you need further assistance or guidance during this process.

If the information is helpful, please Accept Answer and Upvote so that it would be helpful to community members.

Thank you.
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-21T10:28:48.6166667+00:00

Hi PruthvirajHande1-9081,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-22T03:20:52.0933333+00:00

Hi PruthvirajHande1-9081,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.
Pruthviraj Hande 1 35 Reputation points

2024-10-29T17:50:50.9666667+00:00

Dear @Tony & @Syed Saleem Peera ,

Answer Accepted.

I am not aware of how to mark it formally in the portal. I tried to search but couldn't find the button or an option.

This is to confirm that your solution has worked and the problem is solved now.

I could work normally (connect excel file easily to my canvas app in power-app) as soon as I started using MS 365 Business Basic account and associated onedrive to store the excel file.

Thank you for your support and being patient with me.
Pruthviraj Hande 1 35 Reputation points

2024-10-29T18:18:22.36+00:00

I could find the option to "Answer Accepted" But only for @Syed Saleem Peera , and not for @ tony.

Both of you have given me same answer.
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-30T03:31:18.02+00:00

Hello PruthvirajHande1-9081,

Glad to hear that your issue got resolved. Please don't hesitate to reach out to us if you have any further queries.

Thank you.

Answer 2

Chris Carter 0 Microsoft Employee

Check the sensitivity label on the excel file that is downloaded. It's likely automatically classified as sensitive given it's within your OneDrive for Business. I moved it to a lower sensitivity classification and that worked for me!

Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2025-03-03T04:39:48.2366667+00:00

Helo Chris Carter,

Glad to hear it's working for you!

Share via

Unable to link an excel file to powerapps

1 additional answer

Your answer