Forum Discussion

mshao's avatar
mshao
Icon for Helper III rankHelper III
4 months ago
Solved

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

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!

Need Help
  • mshao's avatar
    mshao
    4 months ago

    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

6 Replies

  • tayloramy's avatar
    tayloramy
    Icon for Super User rankSuper User
    4 months ago

    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's avatar
      mshao
      Icon for Helper III rankHelper III
      4 months ago

      Will try this path, thanks for your kindly advice

  • Murtaza_Ghafoor's avatar
    Murtaza_Ghafoor
    Icon for Super User rankSuper User
    4 months ago

    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's avatar
      mshao
      Icon for Helper III rankHelper III
      4 months ago

      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

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support
    4 months ago

    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.

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support
    3 months ago

    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.