Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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.