I have a PQ query which I load to a table and add to the data model in excel Power Pivot. I also have a collection of pivot tables that I project the data model on to.
In Power Pivot, I set some of the columns to be hidden from the client.
In excel, I change the order of the table that the query is loaded to and I delete some of the columns.
I also change the Table Properties to control what happens on refresh.
In this way, I can successfully control the projection of the query on to the spreadsheet surface.
If I later add or change columns in the query, or if I add back a column I deleted in the spreadsheet table, the changes are not reflected in the refresh. And more often than not, power pivot throws an error and disappears from the ribbon.
How is this supposed to work?
The only way I can get it to work is to delete the table and start again.
It's 2018 right? Why is excel still so unstable?
In Power Pivot, I set some of the columns to be hidden from the client.
In excel, I change the order of the table that the query is loaded to and I delete some of the columns.
I also change the Table Properties to control what happens on refresh.
In this way, I can successfully control the projection of the query on to the spreadsheet surface.
If I later add or change columns in the query, or if I add back a column I deleted in the spreadsheet table, the changes are not reflected in the refresh. And more often than not, power pivot throws an error and disappears from the ribbon.
How is this supposed to work?
The only way I can get it to work is to delete the table and start again.
It's 2018 right? Why is excel still so unstable?