Data source credentials is greyed out

[elimey]

I have a report, that gets multiple files from Sharepoint and combine them in tables. 
I am not using Inovke Custom Funtions, to combine them. I simply use the 

= Table.Combine({DS1, DS2, DS3})

when I publish to service, I can't set up a refresh, eventhough all the data sources are sitting in sharepoint. 

I need to mention that I have used shareporitn previusoly alot and normally it works fine. 

Can it be the Table.Combine cause the data source credntials greying out issue?

Please help 

[V-yubandi-msft]

Hi @elimey  ,

Please let me know if my response clarified things for you. If you need any further explanation or additional details, feel free to ask.

[ibarrau]

Hi. It looks like something that use to happen. Check this video out that shows a solution that usually happen with sharepoint or onedrive.

https://www.youtube.com/watch?v=CYSMZxaXNLk

I hope that helps,

[V-yubandi-msft · Accepted solution]

Hi @elimey ,

Thanks for reaching outt. I understand you're running into an issue where the refresh option is disabled and the data source credentials are greyed out in Power BI Service even though your files are stored in SharePoint. You mentioned you're combining multiple datasets using = Table.Combine({DS1, DS2, DS3}), and You think that might be what's causing the problem.

This kind of issue often comes down to how the data is being combined. When you manually merge queries like that, Power BI can treat each file as a separate source. That can lead to an unsupported configuration, which blocks scheduled refresh and prevents you from setting up credentials in the service.

The recommended approach is to use the SharePoint Folder connector instead. This treats all the files in the folder as a single, unified source. Just go to Get Data ->SharePoint Folder, enter your SharePoint site URL (not the individual file URL), and use the built in  Combine File option. Power Query will automatically create a function to handle the combination, and you can tweak it as needed. This setup ensures Power BI recognizes the source properly, so refresh and credentials work as expected.

Helpful reference:

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Solved: Combining tables causing refresh to fail in Power ... - Microsoft Fabric Community

Thanks&regards,

Yugandhar.