Best Practices: Connecting Power BI to Feishu (Lark) Base (Bitable)?

[mshao]

Hi community,

Seeking alternative solutions to connect Power BI directly to Feishu (Lark) Base (Bitable). Native connector missing.

Currently evaluated two approaches:

1. Web API via Power Query: Maintenance heavy. OAuth token expires in 2 hours requiring complex M code for dynamic refresh. Pagination adds friction.
2. ETL to Data Warehouse (Python to DB): Stable but infrastructure-heavy for lightweight reporting needs.

Looking for better alternatives:

• Existing Custom Connector (.mez) for Lark/Feishu?
• Recommended third-party sync tools (Make/n8n/Zapier) bridging Base directly to Power BI datasets?
• Clean Power Query template handling Lark's OAuth2 and pagination gracefully?

Appreciate architectural advice or shared templates. Thanks!

[v-karpurapud]

Hi @mshao 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @mshao 

Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to  @tayloramy and  @Murtaza_Ghafoor  for sharing helpful suggestions.

Could you let us know if the suggested solution resolved your issue? If not, please share any additional details so we can assist further.

Best regards,
Community Support Team.

[Murtaza_Ghafoor]

Hi @mshao,
My recommendation would be 

Feshiu Lark Base does not have built in Power BI Connector, so recommended approach would be staging a data in lakehouse rather than calling comlpex API for reporting purpose, so recommended flow from my end should follow as outlined under. 

Feshiu Lark Base/   ----> n8n or Fabric Notebook  ----> Lakehouse/SQL/Parquest ----> Power BI

If this helps, ✓ Mark as Kudos | Help Others

[mshao · Accepted solution]

Thanks for your advice~ Since we'd like to got the live data from feishu lark base, we don't want to add a workflow to sync the data to database. Thank you so much

[tayloramy]

Hi @mshao, 

If there's no native connector, then I would look at using notebooks and writing some python code to extract the data and load it into a fabric datastore. 

That will be the most efficient way of doing it, and will make handling that token expiry much easier than trying to do it in power query. 

[mshao]

Will try this path, thanks for your kindly advice