Forum Discussion
ADLS vs Databricks for Power BI reporting, seeking advice and best practices.
personally i wouldn't use adls unless the data is small volumes and perfect but it really depends on what you need to do and how much cleaning and transforming you need to do to the data, and the depth and breadth of your data.
databricks will allow you to write sql but also do transformation up stream which is often more efficient and faster with spark technology rather than using power bi compute for some tasks which might be memory and cpu hungry, plus doing it in databricks there is always the opportunity to reuse common data. you should be able to trigger the databricks cluster even if its off. Databricks will also be faster no doubt
Community Championpersonally i wouldn't use adls unless the data is small volumes and perfect but it really depends on what you need to do and how much cleaning and transforming you need to do to the data, and the depth and breadth of your data.
databricks will allow you to write sql but also do transformation up stream which is often more efficient and faster with spark technology rather than using power bi compute for some tasks which might be memory and cpu hungry, plus doing it in databricks there is always the opportunity to reuse common data. you should be able to trigger the databricks cluster even if its off. Databricks will also be faster no doubt