Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Could you refresh the browser to make sure there is no session level cache in the play?
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.
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?
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
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
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.
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.
Your issue sounds like the same one that @Greg_Deckler answers in this thread. Give that work around a try.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.