Package index • fabricQueryR

Discovery

Find Fabric workspaces, items, and workload-specific connection details

FabricItem FabricWorkspace FabricLakehouse FabricWarehouse FabricWarehouseSnapshot FabricSqlDatabase FabricMirroredDatabase FabricEventhouse FabricKqlDatabase FabricGraphQLApi FabricSemanticModel FabricJobItem: R6 objects for discovered Microsoft Fabric resources
fabric_catalog_search(): Search the OneLake catalog
fabric_workspaces(): Discover Microsoft Fabric workspaces
fabric_items(): Discover Microsoft Fabric items
fabric_item(): Discover one Microsoft Fabric item
fabric_lakehouses() fabric_warehouses() fabric_warehouse_snapshots() fabric_mirrored_databases() fabric_sql_databases() fabric_semantic_models() fabric_eventhouses() fabric_kql_databases() fabric_notebooks() fabric_data_pipelines() fabric_spark_job_definitions() fabric_environments() fabric_graphql_apis(): Typed Microsoft Fabric item discovery
fabric_user_data_functions() experimental: Discover Fabric User Data Functions

Connect to and query Lakehouse, Warehouse, and SQL Database endpoints

fabric_sql_tables() fabric_sql_views() fabric_sql_read_table(): Discover and read tables through a Fabric SQL endpoint
fabric_sql_query(): Run a parameterized query against Microsoft Fabric SQL
fabric_sql_connect(): Connect to a Microsoft Fabric SQL target
fabric_sql_connection_info(): Get connection details for a Fabric SQL item

Query and refresh Fabric and Power BI semantic models

fabric_pbi_dax_query(): Query a Microsoft Fabric/Power BI semantic model with DAX
fabric_pbi_refresh() fabric_pbi_refresh_history() fabric_pbi_refresh_status() fabric_pbi_refresh_wait() fabric_pbi_refresh_cancel(): Refresh and monitor a Power BI semantic model
print(<fabric_pbi_refresh>): Print a submitted Power BI refresh
print(<fabric_pbi_refresh_detail>): Print Power BI refresh details

Run Spark statements, reusable sessions, and batch jobs through Livy

fabric_livy_query(): Run Spark code in a temporary Microsoft Fabric Livy session
fabric_livy_session(): Create a Microsoft Fabric Livy session
fabric_livy_sessions() fabric_livy_batches() fabric_livy_session_attach() fabric_livy_batch_attach(): Discover and reattach to Microsoft Fabric Livy work
fabric_livy_batch_submit(): Submit a Microsoft Fabric Livy batch job
FabricLivySession: A Microsoft Fabric Livy session
FabricLivyStatement: A statement submitted to a Fabric Livy session
FabricLivyBatch: A Microsoft Fabric Livy batch job

Discover, load, and read Delta Lake tables in OneLake

fabric_lakehouse_schemas() fabric_warehouse_schemas() fabric_lakehouse_table() fabric_warehouse_table(): Discover OneLake schemas and individual tables
fabric_lakehouse_tables() fabric_lakehouse_load_table() fabric_lakehouse_write_table(): Discover and load Microsoft Fabric Lakehouse tables
fabric_onelake_schema_exists() fabric_onelake_table_exists(): Check whether a OneLake schema or table exists
fabric_lakehouse_read_table(): Read a Microsoft Fabric Lakehouse table
fabric_onelake_read_delta_table(): Read a Delta table from OneLake
fabric_delta_config(): Inspect the optional Python Delta runtime

List, inspect, download, upload, and delete files in OneLake

fabric_onelake_list() fabric_onelake_metadata() fabric_onelake_download() fabric_onelake_upload() fabric_onelake_delete(): Work with files in Microsoft Fabric OneLake
fabric_onelake_read_file() fabric_onelake_write_file(): Read and write R or Arrow objects in OneLake Files
fabric_onelake_shortcuts() fabric_onelake_shortcut_get() fabric_onelake_shortcut_create() fabric_onelake_shortcuts_bulk_create() fabric_onelake_shortcut_cache_reset() fabric_onelake_shortcut_delete(): Manage OneLake shortcuts

Discover, load, and read Warehouse tables in Fabric

fabric_lakehouse_schemas() fabric_warehouse_schemas() fabric_lakehouse_table() fabric_warehouse_table(): Discover OneLake schemas and individual tables
fabric_warehouse_tables(): Discover Microsoft Fabric Warehouse tables
fabric_warehouse_read_table(): Read a Microsoft Fabric Warehouse table
fabric_warehouse_write_table(): Write an R or Arrow object to a Fabric Warehouse table

Discover and read replicated Delta tables in OneLake

fabric_mirrored_database_schemas() fabric_mirrored_database_tables() fabric_mirrored_database_table() fabric_mirrored_database_read_table(): Work with Microsoft Fabric mirrored database tables

Query Eventhouse data, ingest storage or R objects, and export results

fabric_kql_tables(): Discover Microsoft Fabric KQL tables
fabric_kql_query(): Run a KQL query in Microsoft Fabric
fabric_kql_read_table(): Read a Microsoft Fabric KQL table
fabric_kql_write_table(): Write an R or Arrow object to an Eventhouse table
fabric_kql_ingest() fabric_kql_ingestion_status(): Submit and monitor tracked Eventhouse ingestion
fabric_kql_export(): Export a KQL query directly to external storage
print(<fabric_kql_ingestion>): Print a tracked Kusto ingestion handle
print(<fabric_kql_ingestion_status>): Print tracked Kusto ingestion status
print(<fabric_kql_write_result>): Print an Eventhouse R/Arrow write result
print(<fabric_kql_export_result>): Print a KQL storage export result

Explore schemas, execute operations, and collect cursor-based pages

fabric_graphql_query(): Run a query against a Fabric GraphQL API
fabric_graphql_schema(): Inspect a Fabric GraphQL schema
fabric_graphql_paginate(): Read all pages from a Fabric GraphQL query
fabric_graphql_cursor(): Locate pagination information in a GraphQL result
fabric_graphql_collect(): Collect paged GraphQL row objects into a tibble
print(<fabric_graphql_rows>): Print collected GraphQL rows

Experimental discovery and invocation of published Fabric functions

fabric_function_invoke() experimental: Invoke a published Fabric user data function

Run, monitor, schedule, and inspect Fabric item jobs

fabric_job_run() fabric_job_status() fabric_job_wait() fabric_job_cancel(): Run and monitor Microsoft Fabric item jobs
fabric_job_instances(): Inspect Microsoft Fabric job history
fabric_job_schedule_config(): Build a Microsoft Fabric job schedule configuration
fabric_job_schedules() fabric_job_schedule_create() fabric_job_schedule_update() fabric_job_schedule_delete(): Manage Microsoft Fabric item schedules
print(<fabric_job>): Print a submitted Fabric job
print(<fabric_job_instance>): Print Fabric job status
print(<fabric_job_schedule>): Print a Fabric job schedule

Resume, monitor, and retrieve Fabric Core asynchronous operations

fabric_operation_status() fabric_operation_wait() fabric_operation_result(): Monitor Microsoft Fabric long-running operations

Package overview