Forum Discussion

ambtb's avatar
ambtb
Frequent Visitor
9 years ago

Power BI with Sharepoint issues

Hello, I need to get some Sharepoint Lists data to Power BI.   So far I'm having the following issues, using the latest version of Power BI for Desktop.   Using the Sharepoint List DataSource, w...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

ambtb,

I am not able to reproduce your issue in the latest version of Power BI Desktop(2.48.4792.481 64-bit (July 2017)). Do you enter the root URL of your SharePoint online site when connecting to the online list using the connector as shown in the first screenshot? And do you use Microsoft account to connect to the online list as shown in the second screenshot?



Regards,
Lydia

  • ambtb's avatar
    ambtb
    Frequent Visitor
    9 years ago

    Hello,

    I'm using the same Power BI Desktop version, I'm connecting to the root URL of sharepoint site, and using a Microsoft Account.

     

     

    Hera are the screenshots of what I'm getting:

     

     

     

    Best Regards,

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      ambtb,

      It seems that you don't choose SharePoint list source, ensure that you choose relative SharePoint list as shown in the screenshot below. In my scenario, appdata is also empty.



      Regards,

      • ambtb's avatar
        ambtb
        Frequent Visitor
        9 years ago

        Hello,

        thank you for the answer.

         

        I don´t know if I have explained well my issue.

        The problem is exactly that the metadata from the list is not being returned if the list is empty, and with that behaviour is difficult to shape the data (for example, I can't remove columns from the source, or change type, or chage name, or expand because if the list becames empty it gives an error).

         

        I'm doing exactly as you, selecting a list present in the sharepoint site.