Importing Excel file from SharePoint

[Anonymous]

I'm importing an Excel file which contains a table from SharePoint into a dataflow.  I'm testing each query and I'm able to see the data at each step.  However, when I Save and Copy.  Power Query adds an extra step in the data load query and the subsequent queries fail to analyze and the data flow does not save to the workspace. 

The additional step is as follows:

Table.RemoveColumns(#"Imported Excel", Table.ColumnsOfType(#"Imported Excel", {type table, type record, type list, type nullable binary, type binary, type function}))

Why is this happening?  How can I fix this? 

[Anonymous · Accepted solution]

I resolved the issue by collapsing two queries into one. Placing the Navigation step (query 2) after the Imported Excel step (query 1) prevented Power Query from generating the Table.RemoveColumns step in the newly combined query. 

I'll chalk it up to Bad Design on my part... I'll know better for next time. 

[Anonymous]

Thanks edhans for the feedback.  I will post this to the forum.

[edhans]

It is automatically removing all non-data columns. That should not cause an issue. 
I would try it again. If it happens again, I would post this to the ISSUES forum. Issues - Microsoft Power BI Community