Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |