- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Unable to feed on-premises SQL-Server data into Lakehouse
Please advise specific instructions on how it is possible for data from an on-premises SQL server database to be fed into a Lakehouse.
When using Gen2 dataflow to connect to on-premises SQL server via a gateway (client using Power BI Premium), configuring a Lakehouse as the data destination does not work:
If I use a Gen1 dataflow to connect to the on-premises SQL server, and then reference the result of this dataflow using a Gen2 dataflow, interface (most of the time) allows for the Lakehouse to be assigned as the data destination, but then the Gen2 dataflow fails to refresh and gives the following error:
When above dataflow is referenced in a pipeline, the associated run fails and below error message is received:
Trying to connect to the on-premises SQL Server database via a pipeline does not appear to be an option as the only available connection method is "Basic" and there is no option to select the gateway.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- duarte on: Unable to sort months in PowerBI
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on: Fix the Date function in DAX
-
Stinkys
on: Cannot login to community site
-
reubwork
on: May 25 update for Snowflake Connector v2 has broke...
-
dmkblesser
on: Unable to open existing PBIP files
- DamoUK on: Gateway issues
- New 8,019
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,227 -
Data Modeling
4,130 -
Dashboards
4,111 -
Report Server
2,114 -
Gateways
2,112 -
APIS and Embedding
1,964 -
Custom Visuals
1,787 -
Content Packs
523 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Power BI Desktop
1 -
Tips and Tricks
1