Changing a column name gives an error in powerbi desktop

[Forecaster93]

Hi,

I have a dataset with muliple tables in.

For most of the tables there is at least one column name that we are changing.

For some tables the column names can be changed and we can refresh the data fine.

For some tables, when the column name is changed and the data is refreshed then we get an error:

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Error handling external file: 'IO request completed with an error. ERROR = 0x00000005'. File/External table name: 'CURATED/SynapseServerless/Fct.ExchangeRate693535/ACAB31A1-1895-458F-8110-55052DEC3018_21322_0-10.parquet'.
Statement ID: {DC4D151A-DC26-418F-A6BA-34008088A322} | Query hash: 0xC54ADC9BFD4883D3 | Distributed request ID: {CDE949DD-0A8B-4A83-8E03-7E5C882CFBF5}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes..

we are connected to a synapse serverless DB 

so to confirm, loading in the tables from synapse without renaming anything and the data can be refreshed fine.

As soon as a column name is changed then the refresh fails.

below is a full step example of how this error comes:

The exchange rate table:

1.) I do a refresh to check that the data refreshes fine

2.) it refreshes successfully

3.) I go and change the column name called ExchangeRate to have a space so it goes to Exchange Rate 

You can see I have changed the column here to Exchange Rate 

I close and Apply

Next when I go to refresh the data i get the error

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Error handling external file: 'IO request completed with an error. ERROR = 0x00000005'. File/External table name: 'CURATED/SynapseServerless/Fct.ExchangeRate707728/B8275D19-8B3E-409E-A80E-9EF31146FA1B_66718_1-1.parquet'.
Statement ID: {219EDA29-9213-4540-8B28-D4029B3D2E31} | Query hash: 0x1E28A7F40D9D5CF0 | Distributed request ID: {AEFA9E56-CADF-4730-8B40-9C46E7C2CF7C}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes..

Any help much appreciated.

[Forecaster93]

Update: This error seems to have resolved itself, basically has just disappeared. Not sure why, no major changes had been made. I suspect there may have been some kind of update in in the backgorund to Synapse, there is no way to tell unfortunately. 

[Forecaster93]

Hi and thanks for your reply. I have tried changing it from the report view but unfortunately it yields the same results. I have also made sure to load the data first and then rename the columns but it doens't work either. 

[miTutorials]

This is weird but just make sure the rename step is after the data gets loaded.

If this is not working perhaps you can try to rename the column from the report view ?