Forum Discussion

SafetyUser's avatar
SafetyUser
New Member
1 year ago
Solved

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 colu...
Need Help
  • SafetyUser's avatar
    SafetyUser
    1 year ago

    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

     

    With 1.0 selected all the default columns have returned including FVAT

     

    Thank you again.

    SafetyUser

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
1 year ago

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!