Can Power BI load delta lake on Azure Data lake Storage (ADLS) v2?

[dengydongn]

Hello all,

We have a data pipeline running on Databricks, the storage is ADLS v2 mounted to the Databricks, and stored format is delta. The data is shimmed with a SQL table in Databricks and Power BI can access this data using spark connector. However one issue is whenever I need to pull new data in Power BI, I have to wake up the Databricks, because the storage has to be mounted in order to be accessible, which requires the Databricks cluster running. This is slow and costly.

I know generally Power BI supports ADLS v2, however can Power BI access delta lake on ADLS v2 directly? Or I have to store the data in different format on ADLS v2 for Power BI to connect? 

Thanks!!

[v-kkf-msft]

Hi @dengydongn ,

I'm not familiar with data lakes, I found these documents, please check if they are helpful.

https://github.com/delta-io/connectors/tree/master/powerbi 

https://docs.microsoft.com/azure/databricks/integrations/bi/power-bi 

https://towardsdatascience.com/power-bi-connects-to-azure-databricks-44bea6731be7 

Best Regards,
Winniz