Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
lukasz_molinski
Regular Visitor

Setting a data source for gateway from csv file from url

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?image.png
2 REPLIES 2
lukasz_molinski
Regular Visitor

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
Super User
Super User

Check "Skip Test Connection" and try again.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.