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

[wvanpeel]

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-w...

[v-huizhn-msft]

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]

Hide	On demand	‎30‎/‎05‎/‎2017‎ ‎8‎:‎18‎:‎48	‎30‎/‎05‎/‎2017‎ ‎8‎:‎23‎:‎55	Failed	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]

Hi @wvanpeel,

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

Thanks,
Angelia

[wvanpeel]

Hi Angelia,

It does not work fine, I said it "worked" fine in the online service until recently.  

Check my first submission text.  It comes with an error doing a refresh data in the online service. 
In latest Desktop version the refresh works fine and I can re-publish also fine.

Another topic (check last comment) also mentions the same issue.

http://community.powerbi.com/t5/Desktop/Sharepoint-Adapter-FieldValuesAsText-does-not-work-anymore-w...

[v-huizhn-msft · Accepted solution]

Hi @wvanpeel,

You'd better create a ticket support in the bottom of the https://powerbi.microsoft.com/en-us/support/.

Thanks,
Angelia