Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
YannL
Regular Visitor

Calculated Column in Power BI service not available

Hi,

 

I created a list in SharePoint to retrieve information about one of our internal process and I added a Power BI dashboard through the Integrate menu (not the Power BI Desktop option) available in the Microsoft List (image below). After some week, I realized that I needed a calculated column to compute additionnal information based on other fields of the same list and it worked perfectly when I checked them in the list. However, now that I try to add that calculated column into my Power BI dashboard, I don't even see the field in the list of available data.

 

YannL_0-1709737614963.png

 

I tried to "Sync list structure" available in the File menu (image below) and refresh the visual, but the new calculated column field is still not available in the list of fields under the list dataset when I try to edit the dashboard. I tried creating a new dashboard online and it didn't fix the problem and I tried using a calculated column in a complete new list with a new dashboard and it worked fine. Is there a way a force an update of the dataset other than what I already tried. I don't want to recreate the list considering that people are using it daily and I know that I could use Power BI Desktop, but I want to know if it is possible to fix it with available tools online.

 

              YannL_1-1709737920024.png

2 REPLIES 2
v-huijiey-msft
Community Support
Community Support

Hi @YannL ,

 

From your description, we can know that the semantic model when you first created the dashboard did not contain calculated column.

 

The calculated column were created by you later, so it is not feasible for you to add calculated column to the dashboard based on the original semantic model.

 

My suggestion is:

 

Reconnect the existing SharePoint list to Power BI online, which should pull in the current structure of the list, including the new calculated column.

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

lbendlin
Super User
Super User

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.