Forum Discussion

Holger28's avatar
Holger28
Frequent Visitor
9 years ago
Solved

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

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?

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      philipr
      New Member
      9 years ago

      I have the same problem. Any update with this?

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

    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

    • Holger28's avatar
      Holger28
      Frequent Visitor
      9 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Holger28,

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

        Thanks,
        Lydia

    • AJZoerner's avatar
      AJZoerner
      Frequent Visitor
      9 years ago

      Hello Anonymous,

       

      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