cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sam_sonepar
New Member

Calculated columns disappearing

Hi all,

 

I build a report using PBI Desktop. The data source is a SharePoint Online list.

The report has some visualisations based on DAX calculations.

 

When I save and publish, everything is fine. The report and dashboard are looking good and working.

However, the moment I add data in the SharePoint list, my visualisations turn blank.

 

What could be the reason and how could I fix that?

Thanks!

3 REPLIES 3
GilbertQ
Super User II
Super User II

Hi @sam_sonepar 

 

I would go through your PBIX file and refresh the dataset. It would appear that something is changing from your SharePoint list.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User II
Super User II

Hi @sam_sonepar 

 

Is your dataset refreshing successfully?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Nothing happens when I do it in the PBI Service.

 

Had to download everything into a pbix file and refresh the source from there (on the right where we see all the columns and custom measures), then saved and published.

The visualization worked again until I added more data in the SharePoint list.

I tried to repeat those steps again but now it's just not working at all.

 

One thing I noticed is that only my custom measures (with the calculator icon) are not working well. The only visualization that's using the default columns seem to be working correctly all the time.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors