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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
brbrFIAP
New Member

ERROR - Create a DATAFLOW FROM SQL SERVER WITHOUT GATEWAY

I have a database hosted on the internet that can be accessed without logging in to a specific network. I would like to use PBI Dataflow to connect to this database and since it's on the internet, a GATEWAY shouldn't be required to access it. When I try to make the connection, I receive the following message "The connection could not be created. This may mean that it is not accessible from this network or this URI, or that a gateway is required to access this data source. (Session ID: e2e61bec-cc7e-43e1-b5aa-d4ea73fbd8aa, Region: us)" Does anyone have an idea of what might be missing? Just for information, this database is installed on a machine with Ubuntu Server version 20.04.

1 REPLY 1
otravers
Community Champion
Community Champion

Your statement that "since it's on the internet, a GATEWAY shouldn't be required to access it" is incorrect. Infrastructure as a Service (IaaS) virtual machines are considered "on premises" as they have no built-in service to connect to Power BI, unlike DaaS/SaaS such as Azure SQL Server.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors