The following command fails. The /Files/pubs/authors folder contains a single parquet file. This is the authors table from the pubs database.
Please see documentation on how it should work, but does not.
But the "table load" command only works if there is an existing table. We can manually create one by right clicking on the parquet file.
We can make a manual call to the rest api to get it work.
{
"relativePath": "Files/pubs/authors/part-00000-657844e4-6b11-4bbb-bab1-68ead9a5cb7e-c000.snappy.parquet",
"pathType": "File",
"mode": "Overwrite",
"recursive": false,
"fileExtension": "parquet"
}
Make URL path using workspace, lakehouse and table name. Use the -i to leverage json file.
In short, the work around is to call the REST API. But, what I really want is the "table load" command to work.
Recent ideas
Enable writing PowerQuery type time (from Dataflow Gen2) to Warehouse type time
Currently the UI throws an error while I am trying to write Data typed as "time" in Power Query to a Fabric Warehouse. I would prefer to import data typed as "time" in Dataflow Gen2 PowerQue...pyd4life2 hours agoAdvocate INew103Views2likes1CommentAllow sharing of Office 365 Email (Outlook) cloud connections in Manage connections and gateways
The Problem When creating an Office 365 Email (Microsoft Outlook) cloud connection in Manage connections and gateways, it is impossible to share the connection with other users or security groups. A...akim-microsoft3 hours agoMicrosoft EmployeeNew233Views4likes1CommentShow the workspace name for duplicate SQL endpoints with the same name in Desktop PowerBI
When multiple Fabric SQL endpoints have the same name, Power BI Desktop should display the source workspace name alongside the endpoint name during connection and in imported table metadata, so users...WorkFull223 hours agoAdvocate INew1View0likes0Comments