Hi,
We're working within Fabric and with OneLake more frequently for our other data sources in order to make PowerBI reports to visualise and gain insights into the data that we have.
And the reaosn why we're getting our data into OneLake is because it makes the data accessible to users to make reports and it's more user-friendly.
What are the different methods everyone uses to ingest data from LS Cloud (or onprem) into OneLake?
So far, I've tried the Data Gateway to get on-prem LS data into a Azure SQL server, using the GraphQL endpoint to query the data directly in PowerBI PowerQuery. Also using the same script in Fabric Dataflow, then choose a Lakehouse as destination.
But I'm curious to know whether there are more efficient or easier ways to get the data into OneLake?