Excel 2016- Pivot table and Power query

Hi Kaz28EN , thank you for reaching out to the Microsoft Fabric Community Forum.

Thank you Akash_Varuna for your prompt response.

The error message you're encountering indicates that there is an issue with the connection to the external data source in your Power Query. Specifically, it mentions that the source database or table does not exist, or you do not have access to the data source. Additionally, there is a mention of an argument mismatch in a function.

Please consider following below steps:

1. Ensure that the file path in the Power Query is correct and points to the right location. If the file has been moved, update the path in the Power Query Editor.
2. Make sure the file or database you are trying to connect to still exists and has not been deleted or renamed.
3. Ensure you have the necessary permissions to access the file or database. If it’s on a network drive or SharePoint, verify your access rights.
4. Open Power Query Editor -> Data -> Queries & Connections -> right click on your query -> Edit
5. In the Power Query Editor, look for the Source step in the Applied Steps pane on the right. Verify that the source path or connection string is correct.
6. The error mentions a function expecting between 2 and 4 arguments but receiving 5. Identify the function causing the issue. Review the steps in the query to find where this function is used and correct the number of arguments.
7. After making the necessary corrections, click Close & Load to save the changes and load the data back into Excel.
8. Go to the Data tab and click Refresh All to refresh the query and the Pivot Table.
9. Sometimes, there might be hidden steps in the query that are causing issues. Review all steps carefully.
10. If the above steps do not resolve the issue, consider recreating the query

If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.