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,

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,

ambtb's avatar
ambtb
Frequent Visitor
9 years ago

Hello, thank you for your answer.

 

Unfortunetly that expected behaviour can make the sharepoint list datasource difficult to use.

 

I cannot give a report to users based on a sharepoint list that can become empty because in that particular case it will give an error (because of the shaping of the datasource, remove columns, rename, etc) and it is not supposed that the users edit the data model.

 

Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    ambtb,

    When the list becomes empty, please delete the steps to fix this error or remove the list from your PBIX file and re-distribute the report to your users.

    Regards,