DATA SOURCE CREDENTIALS DISABLED

[Anonymous]

Hi everyone!

I'm currently facing a problem while trying to enable the auto-refresh on my PBI dashboard (Power BI online).

I moved all my sources located in my pesonal storage to Onedrive (or Sharepoint, same) but the "data source credentials" is still greyed out.

It seems that PBI online requires me to add "on-premises gateways" as the button cannot be disabled but I don't understand why.

@Idrissshatila Edit : I sent a copy of my file to a colleague so that he could try and see. Guess what ? He has no issue to do it.

So my question now is WHY isn't it working with me ?

Any solutions to solve this ?

Thanks in advance 🙂

[Anonymous · Accepted solution]

Hello, I found the solution.

1. Changed the database authentication:
   1. Desktop App >> File >> Options and Settings >> Data Source Settings >> Edit Permissions >> Privacy Level
2. Deleted the dataset on service and reuploaded.

Thanks for your contribution.

[JibinSebastian]

I have the same issue, Could you please elaborate what exactly you did in the privacy level and what did you deleted after that.

I am connecting to the Fabric Warehouse and My report is in  Import mode. 

I am getting this error.

Data source error: {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"We cannot refresh this semantic model because this semantic model uses a default data connection without explicit connection credentials. Please replace the default data connection in the semantic model settings with an explicit cloud or gateway data connection."}}],"exceptionCulprit":1}}}
Cluster URI: WABI-CANADA-CENTRAL-B-PRIMARY-redirect.analysis.windows.net
Activity ID: bd1e9663-5a7b-45c0-9f36-accf8d94806a
Request ID: f5a8d159-2e80-7d53-d3c6-2723a83689ed
Time: 2025-11-20 19:11:46Z

In the semantic model settings I could see the below screenshot

Could someone help me to fix this issue. any leads would be appriciated

[SaiTejaTalasila]

Hi @Anonymous ,

Are you appending any files data in your applied steps? If yes then you need to check your applied steps.As per my understanding it looks like your applied steps are referencing auto generated helper query for referencing outlook path.

Thanks,

Sai Teja 

[Idrissshatila]

Hello @Anonymous ,

the question is, did you change the datasource in power bi desktop to read from the sharepoint, because if no then power bi can't recognise that you moved them, you need to change the connector in pbi desktop to read from sharepoint.

[Anonymous]

Hello @Idrissshatila,

I did my changes on Power BI desktop.
I don't know why it isn't working...