The query referenced column 'LocalDateTable_8cb1e7c9-3581-4243-aa6e-31336bfdba9f'[Year] which depend

[Dr_Chris]

I've seen a similar problem reported elsewhere but can't get anything suggested to work

I have a PowerBI report linked to a Sharepoint List.

The visuals display fine in the PowerBI App, but not in the Web version.  Any suggestions very gratefully received!
Here are some screen shots

Thanks

Chris

[GilbertQ · Accepted solution]

Hi @Dr_Chris 

It appears that you are using the automated DateTime tables that get created in Power BI Desktop.

I would suggest making sure to create and use your own date table?

Here are more details: Auto date/time in Power BI Desktop - Power BI | Microsoft Docs