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

     

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?