Don't see new columns after Pivot refresh (Analyze in Excel)

[michaelsh]

I add new columns to my Dataset and Publish it to the service.

After that I refresh my existing Excel file that contains connection to this Dataset (Analyze in Excel) and multiple Pivot tables.

I do not see these new added columns even after multiple refreshes... (Data-Refresh All and also individual pivot refreshes)

I have the latest OLEDB driver installed

Please help

[v-eqin-msft]

Hi @michaelsh ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @michaelsh ,

According to your description, it seems that you only refreshed the local data source, but not the dataset published in Power BI service.

Please make sure you refresh the dataset by clicking either these two buttons:

I believe you can get more hints from this official document:

Data refresh in Power BI - Power BI | Microsoft Docs

Configure scheduled refresh - Power BI | Microsoft Docs

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