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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SafetyUser
New Member

Field Value as Text Column has disappeared?

Hi all

 

I am using Power BI desktop to make dashboards with the data source being SharePoint online list.

I have sucsessfully made three dashboards and in their filter query I have converted columns to field value as text - for example the people columns in the sharepoint list.

 

Today however I have attempted to make a new dashboard from a new list. After connecting the data source and then viewing the filter query the field value as text column is not there, nor are any of the other default columns that would usual appear.

 

I have tried to trouble shoot by searching the forum and internet to no avail.

I also tried to use data connections I have sucsessfully used prior, yet they yeild the same rusult. 

 

Any help would be greatly appreciated

thank you 

1 ACCEPTED SOLUTION
SafetyUser
New Member

Thank you both for your replies, I appreciate your time and expertise.

 

I have found the issue that caused the field value as text column not to load when adding the data source from SharePoint Online List.

 

I had mistakenly selected implementation 2.0 instead of 1.0

implementation 1.png

 

With 1.0 selected all the default columns have returned including FVAT

fvat.png

 

Thank you again.

SafetyUser

View solution in original post

4 REPLIES 4
SafetyUser
New Member

Thank you both for your replies, I appreciate your time and expertise.

 

I have found the issue that caused the field value as text column not to load when adding the data source from SharePoint Online List.

 

I had mistakenly selected implementation 2.0 instead of 1.0

implementation 1.png

 

With 1.0 selected all the default columns have returned including FVAT

fvat.png

 

Thank you again.

SafetyUser

Anonymous
Not applicable

Hi @SafetyUser ,

Glad to see you found the solution yourself! Please don't forget to accept your own reply as a solution so other users can find the solution and learn faster, thank you.

Best Regards,
Dino Tao

Uzi2019
Super User
Super User

Hi @SafetyUser 

can you check the actual data source (sharepoint list)?? whether you have proper data present which you trying to add in Power bi..

 

If everything is proper 

 

open you existing report where you have just change the column filed to text and try to refresh that..

if refresh is successful then you dont have to change anything or other wise you have to cancel your last query ( change to text field).

 

I hope this might solve your issue!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
BIswajit_Das
Super User
Super User

Hello @SafetyUser 
As you mentioned above some of your default columns are not loaded you can follow the below steps for verification
1. Verify the column exists and is visible.
2. Ensure filters, permissions, and refreshes are properly configured.
3. Check for unsupported features or custom transformations.
By going through these steps, you should be able to identify and resolve the issue with missing fields

Thanks & Regards

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.