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

Dataset and report do not shown new fields of published dataset in web view. Works when downloaded.

When publishing a new version of a dataset with new fields in a specific table, these fields do not show up in the web interface in the report. When we download the report or dataset as pbix the fields do show up.

 

Is this a known issue? Is that being fixed?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Dataset and report do not shown new fields of published dataset in web view. Works when download

hi, @PeterKarsten 

This is a normal phenomenon. 

When you refresh in power bi service, It is based on the initial query code to update the dataset. But there is no query for the new fields. So it won't appear in power bi service dataset.

When you download it and open in power bi desktop tool, the query will be adjusted in Edit Queries, so it will appear.

Usually, if you want to add new fields into dataset, you need to add it in power bi desktop and the republish it.

here is a similar post for you refer to:

https://community.powerbi.com/t5/Desktop/Add-an-extra-field-from-a-data-source/td-p/35681

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Dataset and report do not shown new fields of published dataset in web view. Works when download

hi, @PeterKarsten 

This is a normal phenomenon. 

When you refresh in power bi service, It is based on the initial query code to update the dataset. But there is no query for the new fields. So it won't appear in power bi service dataset.

When you download it and open in power bi desktop tool, the query will be adjusted in Edit Queries, so it will appear.

Usually, if you want to add new fields into dataset, you need to add it in power bi desktop and the republish it.

here is a similar post for you refer to:

https://community.powerbi.com/t5/Desktop/Add-an-extra-field-from-a-data-source/td-p/35681

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PeterKarsten Frequent Visitor
Frequent Visitor

Re: Dataset and report do not shown new fields of published dataset in web view. Works when download

Hi@v-lili6-msft ,

We have downloaded the dataset, and earlier you did have to refresh to get the new columns. But it appears that opening the file now automatically refreshes the columns. We will have to look further. Thank you for your help.

Community Support Team
Community Support Team

Re: Dataset and report do not shown new fields of published dataset in web view. Works when download

hi,  @PeterKarsten 

Could you please tell me if you have other problem? If not, could you please mark the helpful replies as Answered?

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.