Forum Discussion
Using someone else's credentials
Hi dave_cousins That error message is never very helpful 🙂
What I would suggest is using the maanger's credential in Power BI desktop and making sure the data loads in Power Query and each step of the query works.
I haven't yet overcome this.
An indivudal of the team 'shared' a specific spreadsheet from their folder with me as 'read only' - which permitted me to access it, but it didn't retrieve all the data (I suspect because it couldn't recalculate the cell formulae). When he then gave me 'edit' and 'execute' and 'delete' rights, it was able to retrieve all the data.
Still trying.
Hi dave_cousins,
Thank you for providing additional details about your issue. It appears that the problem is related to access permissions and formula recalculation in the Excel files. Let's address this step by step to resolve it.
I am pleased to hear that granting "edit," "execute," and "delete" rights resolved the issue for the specific spreadsheet shared with you. This indicates that insufficient permissions were likely the root cause. To apply this solution to all spreadsheets within the sub-folders, here’s what you can do:
- Please ensure that your business manager's credentials have "edit," "execute," and "delete" permissions for all sub-folders and files within the SharePoint folder. This will enable Power Query to perform the necessary operations to retrieve the data accurately.
- Certain Excel files may include formulas that require recalculation upon opening. Please ensure that Power Query can initiate this recalculation, which often necessitates editing permissions. It would be advisable to test this with several files to verify.
- Please verify the filtering criteria in Power Query to ensure it accurately targets only the spreadsheets containing the '_Hours' table. This will help prevent errors related to missing tables.
- Please test the Power Query using a smaller subset of spreadsheets to ensure it functions correctly before applying it to the entire set of files.
If this post helps you, please mark it as the solution and give a kudos so that other members of the community can easily find it helpful.