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: Web API via Power Qu...
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

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