Package: fabricQueryR 1.0.1.9000

Luka Koning

fabricQueryR: Access and Manage 'Microsoft Fabric'

Access 'Microsoft Fabric' workspaces, items, and workload endpoints through its web application programming interfaces (APIs). Connect to data in 'OneLake', 'Lakehouse', 'Warehouse', semantic model, and 'Eventhouse' items, with support for 'DBI', 'Arrow', 'GraphQL', and 'Spark'. Manage files, tables, refreshes, jobs, schedules, ingestion, and long-running operations.

Authors:Luka Koning [aut, cre, cph], Kennispunt Twente [fnd]

fabricQueryR_1.0.1.9000.tar.gz
fabricQueryR_1.0.1.9000.zip(r-4.7-any)fabricQueryR_1.0.1.9000.zip(r-4.6-any)fabricQueryR_1.0.1.9000.zip(r-4.5-any)
fabricQueryR_1.0.1.9000.tgz(r-4.6-any)fabricQueryR_1.0.1.9000.tgz(r-4.5-any)
fabricQueryR_1.0.1.9000.tar.gz(r-4.7-any)fabricQueryR_1.0.1.9000.tar.gz(r-4.6-any)
fabricQueryR_1.0.1.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
fabricQueryR/json (API)

# Install 'fabricQueryR' in R:
install.packages('fabricQueryR', repos = c('https://kennispunttwente.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/kennispunttwente/fabricqueryr/issues

Pkgdown/docs site:https://kennispunttwente.github.io

On CRAN:

Conda:

azurefabricpowerbi

6.82 score 6 stars 13 scripts 553 downloads 110 exports 34 dependencies

Last updated from:c5a95a8783. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-develOK279
source / vignettesOK280
linux-releaseOK266
macos-releaseOK174
macos-oldrelOK186
windows-develOK191
windows-releaseOK188
windows-oldrelOK156
wasm-releaseOK114

Exports:fabric_catalog_searchfabric_data_pipelinesfabric_delta_configfabric_environmentsfabric_eventhousesfabric_function_invokefabric_graphql_apisfabric_graphql_collectfabric_graphql_cursorfabric_graphql_paginatefabric_graphql_queryfabric_graphql_schemafabric_itemfabric_itemsfabric_job_cancelfabric_job_instancesfabric_job_runfabric_job_schedule_configfabric_job_schedule_createfabric_job_schedule_deletefabric_job_schedule_updatefabric_job_schedulesfabric_job_statusfabric_job_waitfabric_kql_databasesfabric_kql_exportfabric_kql_ingestfabric_kql_ingestion_statusfabric_kql_queryfabric_kql_read_tablefabric_kql_tablesfabric_kql_write_tablefabric_lakehouse_load_tablefabric_lakehouse_read_tablefabric_lakehouse_schemasfabric_lakehouse_tablefabric_lakehouse_tablesfabric_lakehouse_write_tablefabric_lakehousesfabric_livy_batch_attachfabric_livy_batch_submitfabric_livy_batchesfabric_livy_queryfabric_livy_sessionfabric_livy_session_attachfabric_livy_sessionsfabric_mirrored_database_read_tablefabric_mirrored_database_schemasfabric_mirrored_database_tablefabric_mirrored_database_tablesfabric_mirrored_databasesfabric_notebooksfabric_onelake_deletefabric_onelake_downloadfabric_onelake_listfabric_onelake_metadatafabric_onelake_read_delta_tablefabric_onelake_read_filefabric_onelake_schema_existsfabric_onelake_shortcut_cache_resetfabric_onelake_shortcut_createfabric_onelake_shortcut_deletefabric_onelake_shortcut_getfabric_onelake_shortcutsfabric_onelake_shortcuts_bulk_createfabric_onelake_table_existsfabric_onelake_uploadfabric_onelake_write_filefabric_operation_resultfabric_operation_statusfabric_operation_waitfabric_pbi_dax_queryfabric_pbi_refreshfabric_pbi_refresh_cancelfabric_pbi_refresh_historyfabric_pbi_refresh_statusfabric_pbi_refresh_waitfabric_semantic_modelsfabric_spark_job_definitionsfabric_sql_connectfabric_sql_connection_infofabric_sql_databasesfabric_sql_queryfabric_sql_read_tablefabric_sql_tablesfabric_sql_viewsfabric_user_data_functionsfabric_warehouse_read_tablefabric_warehouse_schemasfabric_warehouse_snapshotsfabric_warehouse_tablefabric_warehouse_tablesfabric_warehouse_write_tablefabric_warehousesfabric_workspacesFabricEventhouseFabricGraphQLApiFabricItemFabricJobItemFabricKqlDatabaseFabricLakehouseFabricLivyBatchFabricLivySessionFabricLivyStatementFabricMirroredDatabaseFabricSemanticModelFabricSqlDatabaseFabricWarehouseFabricWarehouseSnapshotFabricWorkspace

Dependencies:askpassAzureAuthbitbit64clicurlglueherehttrhttr2josejsonlitelatticelifecyclemagrittrMatrixmimenanoarrowopensslpillarpkgconfigpngR6rappdirsRcppRcppTOMLreticulaterlangrprojrootsystibbleutf8vctrswithr

Bring Fabric data into R
Choose a reading method | Discover the data source once | Read with SQL | Read one table without writing a query | Read Eventhouse data | Query a semantic model with DAX | Read a OneLake file | Read through GraphQL or Spark | Scale up with Arrow streams

Last update: 2026-09-23
Started: 2026-08-14

Working with Fabric Lakehouses and OneLake
Find and connect to a Lakehouse | List and read ordinary files | Write or upload a file | Discover and read managed tables | Write an R object as a managed table | Turn existing files into a table | Read a large or historical Delta table

Last update: 2026-09-22
Started: 2026-08-14

Working with Fabric Warehouses
Find and connect to a Warehouse | Prepare a staging Lakehouse for writes | Add rows to an existing table | Replace table data | Scale up with Arrow | More information

Last update: 2026-09-22
Started: 2026-08-22

Bring R data into Microsoft Fabric
Choose a destination | Prepare a small R data frame | Write a Lakehouse table | Write an ordinary OneLake file | Write a Warehouse table | Write an Eventhouse table | Load a file that is already in a Lakehouse | Scale up with Arrow

Last update: 2026-09-22
Started: 2026-08-14

Get started with 'fabricQueryR'
The Fabric objects you will see | Sign in | Find a workspace and an item | Complete a first read | Choose the next guide

Last update: 2026-09-22
Started: 2026-08-14

Working with Fabric Eventhouses (real-time data)
Find a KQL database | Write a small data frame in one call | Queue a tracked batch | Wait and inspect the outcome | Scale up with Arrow | Export a large KQL result to OneLake

Last update: 2026-09-22
Started: 2026-08-14

Working with Livy (Spark)
Before the first call | Run one piece of Spark code | Choose the language that matches the code | Reuse a session for several statements | Submit a complete application file | Use an Environment for repeatable configuration

Last update: 2026-09-22
Started: 2026-08-14

Working with Semantic Models (DAX queries)
Query the model with DAX | Check access before refreshing | Refresh after an upstream update | Use enhanced refresh controls | Diagnose attempts and failures | Inspect history | More information

Last update: 2026-09-22
Started: 2026-08-14

Automate and inspect Microsoft Fabric jobs
Run once and inspect history | Build schedule configurations | Create, list, update, and disable | Delete a schedule

Last update: 2026-09-19
Started: 2026-08-13

Working with GraphQL
Run a first query | Inspect the available fields | Read more than one page | Build an analysis-ready tibble | Treat incomplete pagination as partial data

Last update: 2026-09-05
Started: 2026-08-14

Invoke Fabric user data functions (experimental)
Lifecycle | Prepare the function in Fabric | Make a first call | Send structured parameters | Retry only safe functions | Limits | More information

Last update: 2026-09-04
Started: 2026-08-14

Get started with Microsoft Fabric authentication
Quick start: sign in as yourself | 1. Find your tenant ID | 2. Set the tenant ID in R | 3. Test the connection | 4. Save the settings for future R sessions | Make sure Fabric access has been granted | First-login troubleshooting | How authentication works | Treat endpoint URLs as credential boundaries | Choosing an advanced authentication method | Advanced: authentication for automation | Service principal with a client secret | Managed identities and custom token providers | Set Fabric permissions by workload | Signing out (token cache)

Last update: 2026-08-31
Started: 2026-07-25

Readme and manuals

Help Manual

Help pageTopics
Search the OneLake catalogfabric_catalog_search
Inspect the optional Python Delta runtimefabric_delta_config
Invoke a published Fabric user data functionfabric_function_invoke
Collect paged GraphQL row objects into a tibblefabric_graphql_collect
Locate pagination information in a GraphQL resultfabric_graphql_cursor
Read all pages from a Fabric GraphQL queryfabric_graphql_paginate
Run a query against a Fabric GraphQL APIfabric_graphql_query
Inspect a Fabric GraphQL schemafabric_graphql_schema
Discover one Microsoft Fabric itemfabric_item
Discover Microsoft Fabric itemsfabric_items
Inspect Microsoft Fabric job historyfabric_job_instances
Run and monitor Microsoft Fabric item jobsfabric_job_cancel fabric_job_run fabric_job_status fabric_job_wait
Build a Microsoft Fabric job schedule configurationfabric_job_schedule_config
Manage Microsoft Fabric item schedulesfabric_job_schedules fabric_job_schedule_create fabric_job_schedule_delete fabric_job_schedule_update
Export a KQL query directly to external storagefabric_kql_export
Submit and monitor tracked Eventhouse ingestionfabric_kql_ingest fabric_kql_ingestion_status
Run a KQL query in Microsoft Fabricfabric_kql_query
Read a Microsoft Fabric KQL tablefabric_kql_read_table
Discover Microsoft Fabric KQL tablesfabric_kql_tables
Write an R or Arrow object to an Eventhouse tablefabric_kql_write_table
Read a Microsoft Fabric Lakehouse tablefabric_lakehouse_read_table
Discover and load Microsoft Fabric Lakehouse tablesfabric_lakehouse_load_table fabric_lakehouse_tables fabric_lakehouse_write_table
Submit a Microsoft Fabric Livy batch jobfabric_livy_batch_submit
Run Spark code in a temporary Microsoft Fabric Livy sessionfabric_livy_query
Create a Microsoft Fabric Livy sessionfabric_livy_session
Discover and reattach to Microsoft Fabric Livy workfabric_livy_batches fabric_livy_batch_attach fabric_livy_sessions fabric_livy_session_attach
Work with Microsoft Fabric mirrored database tablesfabric_mirrored_database_read_table fabric_mirrored_database_schemas fabric_mirrored_database_table fabric_mirrored_database_tables
Discover OneLake schemas and individual tablesfabric_lakehouse_schemas fabric_lakehouse_table fabric_onelake_catalog fabric_warehouse_schemas fabric_warehouse_table
Work with files in Microsoft Fabric OneLakefabric_onelake_delete fabric_onelake_download fabric_onelake_files fabric_onelake_list fabric_onelake_metadata fabric_onelake_upload
Read and write R or Arrow objects in OneLake Filesfabric_onelake_object_files fabric_onelake_read_file fabric_onelake_write_file
Read a Delta table from OneLakefabric_onelake_read_delta_table
Check whether a OneLake schema or table existsfabric_onelake_schema_exists fabric_onelake_table_exists
Manage OneLake shortcutsfabric_onelake_shortcuts fabric_onelake_shortcuts_bulk_create fabric_onelake_shortcut_cache_reset fabric_onelake_shortcut_create fabric_onelake_shortcut_delete fabric_onelake_shortcut_get
Monitor Microsoft Fabric long-running operationsfabric_operation_result fabric_operation_status fabric_operation_wait
Query a Microsoft Fabric/Power BI semantic model with DAXfabric_pbi_dax_query
Refresh and monitor a Power BI semantic modelfabric_pbi_refresh fabric_pbi_refresh_cancel fabric_pbi_refresh_history fabric_pbi_refresh_status fabric_pbi_refresh_wait
Connect to a Microsoft Fabric SQL targetfabric_sql_connect
Get connection details for a Fabric SQL itemfabric_sql_connection_info
Run a parameterized query against Microsoft Fabric SQLfabric_sql_query
Discover and read tables through a Fabric SQL endpointfabric_sql_read_table fabric_sql_tables fabric_sql_views
Typed Microsoft Fabric item discoveryfabric_data_pipelines fabric_environments fabric_eventhouses fabric_graphql_apis fabric_kql_databases fabric_lakehouses fabric_mirrored_databases fabric_notebooks fabric_semantic_models fabric_spark_job_definitions fabric_sql_databases fabric_typed_items fabric_warehouses fabric_warehouse_snapshots
Discover Fabric User Data Functionsfabric_user_data_functions
Read a Microsoft Fabric Warehouse tablefabric_warehouse_read_table
Discover Microsoft Fabric Warehouse tablesfabric_warehouse_tables
Write an R or Arrow object to a Fabric Warehouse tablefabric_warehouse_write_table
Discover Microsoft Fabric workspacesfabric_workspaces
R6 objects for discovered Microsoft Fabric resourcesFabricEventhouse FabricGraphQLApi FabricItem FabricJobItem FabricKqlDatabase FabricKqlItem FabricLakehouse FabricMirroredDatabase FabricSemanticModel FabricSqlDatabase FabricWarehouse FabricWarehouseSnapshot FabricWorkspace
A Microsoft Fabric Livy batch jobFabricLivyBatch
A Microsoft Fabric Livy sessionFabricLivySession
A statement submitted to a Fabric Livy sessionFabricLivyStatement
Print collected GraphQL rowsprint.fabric_graphql_rows
Print a submitted Fabric jobprint.fabric_job
Print Fabric job statusprint.fabric_job_instance
Print a Fabric job scheduleprint.fabric_job_schedule
Print a KQL storage export resultprint.fabric_kql_export_result
Print a tracked Kusto ingestion handleprint.fabric_kql_ingestion
Print tracked Kusto ingestion statusprint.fabric_kql_ingestion_status
Print an Eventhouse R/Arrow write resultprint.fabric_kql_write_result
Print a submitted Power BI refreshprint.fabric_pbi_refresh
Print Power BI refresh detailsprint.fabric_pbi_refresh_detail