Forum Discussion
Helper IIIDynamic columns and refresh errors
This is not the same error.
I am using an Excel file that has column names that change because it is a rolling 12 months.
May 2019 would be removed next month, and replaced with June 2019, and errors out.
I went on the advanced query, and made it so it doesn't look at the column names, but rather the positions of the columns.
It works on the Desktop refresh, just not the web version.
Community SupportHi PBIUWO ,
You can refer to below link which has similar issue:
- The 'HasUniqueRoleAssignments' column does not exist in the rowset.
- The column does not exist in the rowset
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
PBIUWOThis is not the same error.
I am using an Excel file that has column names that change because it is a rolling 12 months.
May 2019 would be removed next month, and replaced with June 2019, and errors out.
I went on the advanced query, and made it so it doesn't look at the column names, but rather the positions of the columns.
It works on the Desktop refresh, just not the web version.