cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
h8pvmt Frequent Visitor
Frequent Visitor

Publish not updating new data columns

Hi,

 

I've added new columns to a data set in Power BI Desktop.  When I publish and confirm to replace the existing data set the new columns do not show up on PowerBI.com.  How do I resolve this?

 

Thanks.

 

Al

9 REPLIES 9
Super User
Super User

Re: Publish not updating new data columns

@h8pvmt

Your issue sounds like the same one that @Greg_Deckler answers in this thread. Give that work around a try.

 

http://community.powerbi.com/t5/Integrations-with-Files-and/Can-we-update-the-dataset-without-deleti...

Near SE WI? Join our PUG Milwaukee Brew City PUG
Super User
Super User

Re: Publish not updating new data columns

Actually, I think this sounds like another thread where someone updates their Excel file on their OneDrive and the new stuff shows up an hour later, I'm going to test this and report back.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: Publish not updating new data columns

OK, I just tested this and it is working fine in my tests. Published a PBIX file, went to data set page to view fields. In Desktop, created a new field, publish. Refresh browser and it is there. Going to try adding a new column that isn't a calculated column.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: Publish not updating new data columns

OK, tested this adding a column to the source and then carrying it through.  Same steps as above, publish data model, go to source, add column, refresh query, new column in data model, publish, refresh browser, new column in service.

 

One thing, are you sure that there is nothing in the query that might exclude those new columns? Are you certain they are making it into the data model?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Power BI Team meysun
Power BI Team

Re: Publish not updating new data columns

Could you refresh the browser to make sure there is no session level cache in the play?

h8pvmt Frequent Visitor
Frequent Visitor

Re: Publish not updating new data columns

Thanks for the reply (sorry for the delay).  It is a calculated column that I added to my pbix model -- apologies for not being specific as I didn't know that was an issue.  So what I'm hearing is that the only way to get a calculated column to show up is to delete the old model on PowerBi.com and the publish again from PowerBI Desktop, correct?  And doing so means all reports/dashboards would have to recreated, correct?  Bugger.

 

Thanks for any workaround suggestions you may have.

 

Al

Power BI Team meysun
Power BI Team

Re: Publish not updating new data columns

I tried out the below and it worked

 

1. Created Sales.pbix in Power BI Desktop and published.

2. Add a calculated column using the New Column ribbon button under Calculations ribbon group

3. Published the file and clicked the URL to open up the report. Clicked 'Edit report' and saw the new Column right away.

Super User
Super User

Re: Publish not updating new data columns

So, not exactly. There are two conditions, both of which must be true to run into this. If you add calculated columns and then try to add a column to your source data import, it wilk not be imported into the model until you remove your cacalculated columns and do a refresh. That is the only instance ththat I know of where you run into this.

 

That said, it is quite painful when you run into it  


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


gvanbrunt Frequent Visitor
Frequent Visitor

Re: Publish not updating new data columns

I found a better work around for anyone that sees this. Instead of removing all calculated columns, add a new "fake" one. This schema is updated and all data shows up after a refresh.