'Column name' in table 'Table Name' does not have its source pipeline rowset column specified"

[Anonymous]

Hi,

I want to refresh my model in the Power BI service and I get the following error. 

Does anyone know how should  I solve it?

Thanks in advance, 

[v-janeyg-msft]

Hi, @Anonymous 

Have you changed this column name in the data source? Or do other operations on the table in the data source?

Once the dataset is published and refreshed, if a change needs to be made to the model or reports, it needs to be republished from Power BI Desktop to the service. So I think you may need to start from scratch.

It is not recommended to modify the report using incremental refresh in the service. In case it is better to modify it in the desktop, you only need to upload it to the service again.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[bcdobbs]

Do you have access to the original PBIX and does it refresh locally?

[Anonymous]

Hi!

I do have access to the original PBIX but I've made a lot of updates on the service so I don't use it anymore -

and I can't download the report to desktop PBIX as I set an incremental refresh to the report. 

[bcdobbs]

Is it in premium

capacity or running with a Ppu licence?

[Anonymous]

Ppu licence

[bcdobbs]

Never the seen the issue in Power Bi but something similar when refreshing a SSAS partition.

I'd start by connecting to the datasets XLMA end point with tabular editor. (free version is fine). (Can send some instructions)

See if triggering an automatic refresh with it gives anything new in an error message:

You can also navigate down and try and refresh an indivdual partition:

[bcdobbs]

Actually thinking about it before assuming it's partition related have a look at the following property in the tabular model (with tabular editor connected to XLMA end point):

Source Column should match the column name coming from the underlying M however if an underlying table/view in your source system has been modified it might not line up.

[PriyanshuVatsa]

this worked in my case. the data model had been edited manually for adding extra columns which was present in source dataset but source column name was blank for these explicitly added columns

[bcdobbs · Accepted solution]

If you had a free trial version of Tabular editor 3 you could right click the table and ask it to update table schema which would sort it out if something had changed at source.