Forum Discussion

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

v-huizhn-msft
9 years ago
Hi wvanpeel,

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

Thanks,
Angelia

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

Advocate II

9 years ago

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.

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
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
- wvanpeel
  Advocate II
  9 years ago
  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-with/m-p/172057#M75167