Sharepoint Adapter: FieldValuesAsText does not work anymore with Power BI Desktop May 2017 version

[Holger28]

FieldValuesAsText does not work anymore with Offoce 365: Normally you can get all SharePoint List column values as text from this column. This does not work anymore. Instead I get one single field with cryptic name. What happended?

[v-yuezhe-msft · Accepted solution]

Hi @Holger28 @philipr,

Based on my test, this issue has been fixed in the latest version of Power BI Desktop(2.46.4732.721), please install the new version of Power BI Desktop.

Regards,
Lydia

[AJZoerner]

Hello @v-yuezhe-msft,

I have downloaded to latest version of Power BI Desktop and the issue seems to be resolved within the Desktop program. I then publish the report to Power BI, so that my entire group can view it. The report publishes fine and the data is correct until the report refreshes. Then, the report reverts back to having this issue. The only solution is for me to then download a copy of the pbix, refresh the data within Power BI Desktop, publish it to Power BI and replace the old file. This is not a plausible solution, as this report is set to automatically refresh, so this would require me to download, refresh, and republish after every refresh.

Thanks,

Amy Jo

[Holger28]

I just installed this new version and can confirm that the issue is gone, problem solved! Thank you very much!

[v-yuezhe-msft]

Hi @Holger28,

You can mark helpful replies as answer to close this thread.

Thanks,
Lydia

[v-haibl-msft]

@Holger28 @philipr

The product team confirm that this is a bug, and expect to release an update to Power BI Desktop in the middle of next week (~5/16).

Best Regards,
Herbert

[v-yuezhe-msft]

Hi @Holger28,

I can reproduce your issue in Power BI Desktop May version, I will report this issue internally and post back once I get any updates.

Thanks,
Lydia Zhang

[philipr]

I have the same problem. Any update with this?