chris-bowman/Azure-Cost-Reporting

RI Transactions - The column 'id' of the table wasn't found.

Closed this issue · 4 comments

ChiefChronoX commented

When trying to use your report template and filling out the information, the report is trying to refresh the tables and I get below error which is blocking all other tables from being refreshed.

Could it be because I'm not 100% sure if I'm using the correct DefaultOfferId? I assume it's the subscription ID?

thumbnail_image001

chris-bowman commented

Strange, I have not seen this error, although have only been able to test with an Enterprise Enrollment (with and without any Reservation transactions). Are you using an Enterprise Enrollment or Billing Account (MCA)? MCA is not yet supported, but will be in a new release soon. DefaultOfferId will also be removed.

mborgers commented

I've encountered the same problem. I'm using the Enterprise Enrollment ID. The query can't find the id at reordered columns:
ID Error
I removed 'Reorderd Columns' and 'Removed Columns' and now the report seems to be working. However I have no idea on the impact that this will have.

ChiefChronoX commented
chris-bowman commented

Ah glad to hear it has resolved with 3.1 - I actually removed the reorder columns step. I did notice that if no reservations have been purchased, then the 'id' column disappears from the dataset, which may account for it.

Resolved by #7