Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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, 

 

  • 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.

9 Replies

  • bcdobbs's avatar
    bcdobbs
    Community Champion

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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's avatar
        bcdobbs
        Community Champion

        Is it in premium

        capacity or running with a Ppu licence?

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support

    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