Using someone else's credentials

Hi dave_cousins 

Thanks for reaching out to the Microsoft Forum community.

It appears that you are experiencing an error when attempting to refresh your Power Query in Power BI using your business manager's credentials. This issue seems to arise from Power Query being unable to locate the '_Hours' table in one or more Excel spreadsheets stored in a SharePoint folder. Please follow these troubleshooting steps to help resolve the issue:

• Check that all spreadsheets contain the table named '_Hours'. The error message suggests that Power Query is unable to find the '_Hours' table in one or more spreadsheets.
• Ensure that your business manager's credentials have full access permissions to all sub-folders and files within the SharePoint folder. This includes verifying that they can view all relevant spreadsheets.
• Review and adjust the filtering criteria in Power Query to ensure it accurately identifies and selects only the spreadsheets containing the '_Hours' table.
• If any Excel sheets have been renamed recently, ensure that all references in Power BI are updated accordingly. A change in sheet name can lead to errors if Power BI is trying to access a sheet that no longer exists under its previous name.
• Check that the '_Hours' table is visible. Power Query cannot access hidden tables, so this step ensures that data retrieval is not hindered by visibility settings.

If this post helps, please give us Kudos and consider accepting it as a solution to help other members find it more quickly.

Thank you.