Forum Discussion

pfurbish's avatar
pfurbish
Frequent Visitor
4 years ago
Solved

Selecting a FieldValuesAsText record throws a Bad Request error.

In Power BI desktop (Version: 2.102.845.0 64-bit February 2022), I have 3 simple SharePoint lists (which I recently created) that are queried to create 3 tables.  Two of them work as expect.  For the...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi pfurbish - can you please check the Advanced Editor screen to see if you are using the either of the following:

     

    SharePoint.Tables( URL, [Implemention=""])
    SharePoint.Tables( URL, [Implemention="2.0"])

    You will find the Implementation="2.0" work faster, and it not longer provide access to the FieldValuesAsText and FieldValuesAsHTML. 

     

    This suggests that in the long-term Microsoft does not want people using these nested tables.

     

    Many thanks

    Daryl

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi pfurbish - can you please check the Advanced Editor screen to see if you are using the either of the following:

 

SharePoint.Tables( URL, [Implemention=""])
SharePoint.Tables( URL, [Implemention="2.0"])

You will find the Implementation="2.0" work faster, and it not longer provide access to the FieldValuesAsText and FieldValuesAsHTML. 

 

This suggests that in the long-term Microsoft does not want people using these nested tables.

 

Many thanks

Daryl

  • pfurbish's avatar
    pfurbish
    Frequent Visitor
    4 years ago

    I tried your Html.Table function solution and it's working.  Your detailed example was very helpful.  I expect I may need to adjust the CSS selectors as the data gets more complicated but this is a good start and needed for when FieldValuesAsText goes away.

     

    Thanks for your time and effort on this.