Hi Please help me. I have created an external table in the synapse lake database, Now I like to load the records from the external table into the dedicated SQL pool table. Please advice on the procedure.
Just wondering why you bothered with a pipeline . I think when source data is in the Lake you can use serverless sql to create external tables (parquet) which can feed power bi (with or without views)
@9:27 made it this far with no issues, but when I run my query I get an empty set as a result (only my column headers show) I have a feeling my parquet file is not being created properly (i have made extra sure to carefully follow these steps), thoughts? Also, I notice my CSV gets truncated, the last few rows don't show on the upload preview, is this normal behavior?