Dataset missing credential

[Apple08]

Hi All

I am unable to set schedule refresh due to the error below

Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
Cluster URI: WABI-NORTH-EUROPE-G-PRIMARY-redirect.analysis.windows.net
Activity ID: 8980960f-465f-4e0f-947b-7b887356e151
Request ID: b0b1501a-238b-910d-ca82-b917064d178e
Time: 2021-09-14 11:16:51Z

I have checked the data source setting and they look fine, I wonder is there a way to find out what and where the credentials are missing

Thanks.

[Apple08]

Thanks Ibendlin.  I just want to change the data source location to SharePoint instead of starting from the scratch.  I tried to paste in the SharePoint folder URL in but it showed a warning sign saying 'The folder path must be a valid absolute file path'. 

I have already combined the data from the original source, therefore I just want to change the source to SharePoint to keep all the work that I have already done... I wonder is it possible?

[lbendlin]

the sharepoint path can only be the main site path.  The rest of the navigation (down to your target folder) is done in Power Query.

[Anonymous]

@Apple08 

Are you using dataflow or multiple datasources? Go to the pbix file, check the data sources setting option in Power BI Desktop, you have to make sure every datasource you connected have an valid credentials. Go to the pbix file, check the data sources setting option in Power BI Desktop.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Apple08]

Thank you all.  I think the issue is I have a folder included multiple regular monthly reports and I have to add in new reports in the same format each month.  I need to connect the SharePoint link to the Power BI.  I have already built up graphics by using the data from the original area, however I just noticed the original area hasn't got a gateway to connect with the Power BI.  Therefore I have moved the reports with a folder to my SharePoint site.  Then the issue is how can I reset the data sourcing link.  

I have created two parameters:

SharePoint_Site and Folder_location

The files are in xlsx format and I am not sure what should I do next to connect the paremeters with Power BI.  Please any help would be appreciated.

[lbendlin]

Instead of connecting to individual files you connect to the sharepoint folder and then tell Power Query to "combine all Excel files that match a pattern into one output table"

[lbendlin]

re-enter the credentials for all data sources even if they "look fine"