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.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        ambtb,

        This is expected behavior that empty SharePoint list show as an empty table in Power BI Desktop.

        However, when you connect to a non-empty SharePoint list in Power BI Desktop and implement some modeling on the imported query, if you delete all items in the SharePoint list, then refresh data in Power BI Desktop you will get error. In this case, open query editor in Power BI Desktop, click on your query , and you will see APPLIED STEPS in Query Setting panel, delete the steps(Renamed Columns ,Change type and so on), the error should go away.


        Regards,