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.