Forum Discussion

tbrown33's avatar
tbrown33
Regular Visitor
4 years ago
Solved

Modify source table with re-publishing

Hi have data coming from a server published to Power BI service.  Is there a way to make changes to a table (add or remove columns in the dataset) without re-publishing the dataset.  Updates don't come through when I refresh.      

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi tbrown33 ,

     

    If you want to update the data model but don't want to republish the report, this won't work. Not only that, you have to go to the advanced editor in the query editor to check if the columns you deleted or added still exist before republishing the report.

    Also, if you update the data model, your report will not change if the deleted or added columns are not referenced in the report. Conversely, it will definitely be affected.

     

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    Depends on the source, but no visuals will update. You'll just get more data in the model that won't be used. You have to create measures or add fields to visuals.

  • tbrown33's avatar
    tbrown33
    Regular Visitor
    4 years ago

    The visuals not updating would be fine.  What I'm trying to do is update a dataset (add or remove columns) published to the service coming through the gateway.    A report is already created and I would like to make data model adjustments without loosing the report.   The report gets deleted when I re-publish the updated dataset. 

     

    I'd like to be able to update the dataset and keep the existing report as is.      Is this possible?  

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi tbrown33 ,

     

    If you want to update the data model but don't want to republish the report, this won't work. Not only that, you have to go to the advanced editor in the query editor to check if the columns you deleted or added still exist before republishing the report.

    Also, if you update the data model, your report will not change if the deleted or added columns are not referenced in the report. Conversely, it will definitely be affected.

     

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.