Forum Discussion

wvanpeel's avatar
wvanpeel
Advocate II
9 years ago
Solved

Sharepoint Adapter: FieldValuesAsText does not work in PowerBI service as from May

This issue that started early May, seems to be fixed in the latest Desktop version, but after doing a refresh in the online Service it still fails.

I have reports refresh from Sharepoint lists twice a day, now I need to refresh in the Desktop version and publish each time.

Pls fix this soon !!

 

http://community.powerbi.com/t5/Desktop/Sharepoint-Adapter-FieldValuesAsText-does-not-work-anymore-with/m-p/172057#M75167

 

Need Help

5 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi wvanpeel,

     >>but after doing a refresh in the online Service it still fails.

    Could you please share your error message for further analysis?

    Best Regards,
    Angelia

    • wvanpeel's avatar
      wvanpeel
      Advocate II
      9 years ago
      Hide
      		On demand‎30‎/‎05‎/‎2017‎ ‎8‎:‎18‎:‎48‎30‎/‎05‎/‎2017‎ ‎8‎:‎23‎:‎55Failed

      There was an error when processing the data in the dataset.

      Hide details
      Data source error:The 'GeographicalArea' column does not exist in the rowset.
      Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
      Activity ID:dcd00d59-cbc4-41e5-8529-9061532e6dfa
      Request ID:36238d7d-d037-e1e4-0c43-84bde2453a48
      Time:2017-05-30 06:23:55Z

       

      This column 'GeographicalArea' is extracted from  FieldvalueasText. 

      It worked fine until recently.

       

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi @wvanpeel,

        It's amazing, tt works fine? Please mark your right reply as answer. So more people will benefit from it.

        Thanks,
        Angelia