Forum Discussion
Adding data from Sharepoint ends with Error
Hi, I need a help with adding excel files from Sharepoint to PBI. I have sucessfully chosen desired file from a list on the sharepoint but then I am getting transformation error: An error occurred i...
Hi,
thanks for answers. the problem was solved by selecting Sample parameters instead of Spreadsheet as adviced in the guide https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Hi Anonymous ,
Seems like you have a query in which a row is selected based on a key value 'status change 'and that value does not exist.
To fix it make sure the key value exist or adjust the code so it does not point to a non-existing key value.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.