Data not refreshing when I pivot a column

[HunterAlpert]

Hello,

I am experiencing an issue where when I pivot a column, that my data is not able to refresh. It just gets stuck on "evaluating". 

I started with making a conditional column, and then pivoting the values dependent on that conditional colum into 4 unique columns. However, while my data will refresh before I apply these steps, after I introduce them, the desktop app will be stuck on evaluating, and I can only refresh my dataset from the online application. Is there something I can do to fix this? My datatset is being pulled from a sharepoint list. 

-Thanks!

[v-deddai1-msft]

Hi @HunterAlpert ,

Please try to turn off below option:

Also you can follow this article to optimize you data model, then refresh it again to see if the issue is mitigated. 

In addition, pay attention to Data Privacy Settings.  https://blog.crossjoin.co.uk/2017/05/24/data-privacy-settings-in-power-bipower-query-part-1-performa...

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

Best Regards,

Dedmon Dai

[GilbertQ]

Hi there

Can you please make sure you have got the latest version of Power BI Desktop installed?

While I know that this is for SharePoint Files this could possibly help you with your SharePoint list? 

https://www.thebiccountant.com/2020/11/16/improve-file-import-from-sharepoint-in-power-bi-and-power-...

[HunterAlpert]

Funnily enough. This issue didn't start happening until I updated to the latest version.