Hi Patrick Bergin , Thank you for reaching out on the Microsoft Q&A forum. After the data preview is displayed, you must click the table that you want to load or transform. Once you select the table, the "Load" and "Transform" buttons will become enabled, allowing you to proceed with the desired action. We tried it on our end, and it's working fine. Kindly refer to the screenshot below for further clarification. If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you. If the information is helpful, please Accept Answer and Upvote so that it would be helpful to community members. Thank you.

Trying to get data from excel, it displays in the preview ok but load and transform buttons are greyed out. What am I doing wrong?

Accepted answer

Syed Saleem Peera 9,620 Reputation points Microsoft Vendor

2024-12-23T10:38:20.8733333+00:00

Hi Patrick Bergin,

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

After the data preview is displayed, you must click the table that you want to load or transform. Once you select the table, the "Load" and "Transform" buttons will become enabled, allowing you to proceed with the desired action.

We tried it on our end, and it's working fine. Kindly refer to the screenshot below for further clarification.

If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

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

Thank you.
Please sign in to rate this answer.

1 person found this answer helpful.
Patrick Bergin 20 Reputation points

2024-12-23T10:42:07.27+00:00

Unfortunately that doesn't work for me. I'd already tried doing this previously but have just tried again. Clicking on the table doesn't change anything for me. The buttons are still greyed out. As per the screenshot I attached earlier.

Syed Saleem Peera 9,620 Reputation points Microsoft Vendor

2024-12-23T13:04:33.33+00:00

Hi Patrick Bergin,

Please share the screenshot once you have selected the table.

Patrick Bergin 20 Reputation points

2024-12-23T13:34:07.8833333+00:00

As I said before, the screenshot looks exactly the same as the one I shared earlier. But just to prove this, here's another screenshot. This is me trying to click on the table... nothing happens.

Patrick Bergin 20 Reputation points

2024-12-23T14:43:00.04+00:00

Ok, I've now worked out how to do it.

Syed Saleem Peera 9,620 Reputation points Microsoft Vendor

2024-12-24T07:17:04.09+00:00

Hello Patrick Bergin,

Please select the checkmark as highlighted below to confirm your choice.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Thank you.

Syed Saleem Peera 9,620 Reputation points Microsoft Vendor

2024-12-24T12:38:58.31+00:00

Hello Patrick Bergin,

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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Trying to get data from excel, it displays in the preview ok but load and transform buttons are greyed out. What am I doing wrong?

0 additional answers

Your answer