"Missing Credentials" on Power BI Service but not on Power BI Desktop

[Boja]

Hello guys,

We are experiencing problem with sceduling refresh on the source. The file in tsv format is saved in the Cosmos storage and we are importing it using the following code:

Source = Csv.Document(Web.Contents("https://cosmos14.osdinfra.net/cosmos/skypedata.a....XXX.tsv"),[Delimiter="#(tab)", Columns=11, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    

This works great in Power BI Desktop. It is connected to the source using Windows credential and has Oganizational Privacy Level. However, when published on Power BI Service, I got an error no matter which credential i try to use (Windows, Basic, Anonimous). Several peoiple in the company tried out and it didnt work for anybody. Could you please advise? Or tell us what is another way to import the tsv file from the Cosmos.

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.

Thank you for looking into the issue.

[v-jiascu-msft · Accepted solution]

Hi @Boja,

Why not using the Cosmos connector directly? Please refer to the snapshot below.

Did you use a Gateway? If not, I'm afraid there isn't a Windows credential that can be used in the cloud. I also found a similar error in the Log database. Please refer to the below.

>>>UpdateCredentialsInternalAsync: CredentialType 'Windows' not supported for cloud refresh.

Best Regards,

[Boja]

Thank you @v-jiascu-msft!

We tried and using Gateway worked well for us.