Wei Ding on 19 Mar 2024 04:36:41
Currently, Power BI datamarts are accessible through SSMS for querying data using SQL. However, this approach limits connectivity for tools like Azure Data Factory (ADF) and Python libraries (e.g., pyodbc) that are often used for data manipulation and automation. Enabling direct connections between these tools and Power BI datamarts would be a significant improvement. As companies increasingly move towards a data fabric (Power BI) centric approach, where end users primarily interact with Power BI datasets, this functionality becomes even more crucial.