Setting a data source for gateway from csv file from url

[lukasz_molinski]

I'm trying to set a data source in my gateway to make a scheduled refresh. I used an url like following https://darlene.sdf.atm.pl/foldername/log.csv as a web data source in my PBI Desktop. No credentials are needed meening everyone can access this url. In PBI desktop it works fine, but whenever I try to set a source in my gateway it is throwing me errors:

Unable to create data source. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.



Details: Nordic BI Enterprise Gateway: Unable to connect to the remote server Please have this information handy if you choose to create a support ticket. ActivityId: 2521a7f5-a7bc-4a7d-8ac5-7c25d842d9c1 RequestId: de339567-68a9-40af-beb1-bbaae2d8d6bb Cluster URI: https://api.powerbi.com Status code: 400 Time: Thu Apr 06 2023 21:59:03 GMT+0200 (Central European Summer Time)

Does it mean it is not supported in web service and if so is there any workaround to achieve this?

[lukasz_molinski]

Well,  @lbendlin it's allowing me to add a data source when skipping test connection but whenever trying to refresh it is giving me errors lik this:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Unable to connect to the remote server"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://darlene.sdf.atm.pl/name/log.csv"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: wejścia zdalne.

[lbendlin]

Check "Skip Test Connection" and try again.