"Import from excel" greyed out

(0) Share

Report

Posted on by smanderson

I'm having an issue importing data into entities from excel or other data sources.

My option to get data from excel is greyed out.

When I try to "get data" using the button, I can navigate to the file and choose the table, but when I click the "transform data" i get an unexpected error message with the following text

section Section1;
shared Query = let
Source = Excel.Workbook(Web.Contents("https://my_sharepoint_site_library/facilities.xlsx"), null, true),
Navigation = Source{[Item = "Table1", Kind = "Table"]}[Data]
in
Navigation;

any assistance would be much appreciated.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @smanderson,
Are you a system administrator on the CDS environment? If not, can you check that you have privilege "Export to Excel" to any of the role(s) assigned to you?
Hope this helps!

Was this reply helpful? Yes No
smanderson 6 on at

Like (0)

Report
Copy link

Link copied!

I am the creator of the environment. Just to be sure I went and made sure I had environment administrator and environment customizer roles.

Based on advice from the documentation, I gave myself the customizer role as well.

Still no change.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @smanderson ,

Having ruled out the possibility of security role, I'm more inclined to think it's a browser issue since I cannot reproduce your issue on my side.

Please consider take a try to clear cache of your browser, upgrade browser to the latest version Or change to use IE browser, and make sure your Network is in a good condition, then try it again, check if the issue is solved.

Sik

Was this reply helpful? Yes No
smanderson 6 on at

Like (0)

Report
Copy link

Link copied!

the option to import from excel is still greyed out, but at least I can set up data connections by using IE.

Thank you!

Was this reply helpful? Yes No