Read data from Fabric Warehouse or Lakehouse via API

[goflse]

Hi!
We have our D365 data in a Fabric Lakehouse and transformed views in a Fabric Warehouse. We need to read that financial data into an external Budgeting system via API. Either the raw data in the Lakehouse or the transformed data in the Warehouse.
We haven't got the API to work other than seeing the table metadata via the API. The data itself can't be exracted. What options are there?

[goflse]

Important note!
When we tried to add a new table to the API all previously activated tables were de-activated. This means that if you want to add a table or view, all previosly activated items must be chosen as well, otherwise they are lost from the schema. We consider this a bug.

[goflse]

Tested GraphQL API successfully

[v-ssriganesh]

Hi @goflse,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[goflse]

Thank you. We will try this.

[v-ssriganesh · Accepted solution]

Hello @goflse,
Thank you for reaching out to Microsoft fabric community forum.

We would like to acknowledge @nilendraFabric helpful response. The GraphQL API is indeed a robust and flexible solution for accessing data from your Fabric Lakehouse and Warehouse into your external Budgeting system.

Alternatively, you can explore the Power BI REST API if your data is modelled within a Power BI dataset. This API allows you to extract data into external systems, providing another pathway depending on your setup and requirements.

🔗 Reference Documentation: Power BI REST API Overview

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.

[nilendraFabric]

Hello @goflse 

please use graphql api in Fabric to share data.

https://learn.microsoft.com/en-us/fabric/data-engineering/api-graphql-overview

The Microsoft Fabric API for GraphQL is designed to expose data from various Fabric data sources, such as Data Warehouses, Lakehouses, Fabric SQL databases, Azure SQL databases, Datamarts, and mirrored databases, as a single, unified GraphQL endpoint. This endpoint allows external applications to query data directly.

The API abstracts the complexities of the underlying storage systems and provides developers with a simple query language to retrieve exactly the data they need. It supports features like schema discovery, automatic generation of queries and mutations, and the ability to expose specific objects or columns from data sources. This makes it easier for developers to integrate and interact with Fabric data sources without managing multiple APIs or complex backend logic

if this helps please accept the answer and give kudos

[goflse]

Are there any tips on how to filter out records for the last 30 days for example. Filtering seems to be based on fixed values such as a specific date