Forum Discussion
Power BI with Sharepoint issues
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,
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.
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,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,
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,