Refresh issues

Hi there! It sounds like you've updated the parameter and folder path, but the refresh error might still be due to how Power BI is handling the SharePoint data source.

Here are a few steps you can try to troubleshoot and fix this:

1. Check the Parameter URL Format: Sometimes, Power BI is picky with the format of the SharePoint URL. Make sure the new root URL is in the correct format (usually without any extra subfolders or query strings at the end). For example, it should look like `https://yourcompany.sharepoint.com/sites/YourSite`.

2. Clear Permissions:
- Go to File > Options and Settings > Data Source Settings.
- Look for the old SharePoint URL in the list and clear its permissions.
- Then, reconnect with the new URL so that Power BI refreshes its cached permissions with the updated location.

3. Verify Table Connections: Sometimes, each table might have retained some reference to the old path. Double-check each table’s Source step in the Query Editor to ensure they all point to the updated parameter correctly.

4. Re-enter Parameter in Data Source Settings:
- Go back to Data Source Settings.
- Re-select your parameter as the data source, then reapply it to make sure it recognizes the updated URL.

5. Check Applied Steps:
- For each table, verify all applied steps in the Query Editor. Sometimes an additional step may be using the old path, even if it doesn’t show an immediate error.

Try these steps and let me know if that resolves it! This should refresh your dataset with the new SharePoint folder path.