Forum Discussion
How to connect to Power BI's datamarts using ADF or Python?
Hi there,
I managed to connect to Power BI datamarts via SSMS, using datamart's Connection Straing and AAD Integrated. However, I can't connect to it using ADF, neither Python.
I found a few posts on the internet, but I don't think they still work. They seem need the server name and database name, etc. Currently PowerBI datamarts's Connection string is in the form of ".....datamart.fabric.microsoft.com". Has anyone managed to connect using ADF, and also Python? Thanks.
Ok, I got confirmation from Microsoft that ADF and Python connection are not supported at the moment. I raised this idea on Microsoft Idea. If you have the same requirement, please help to vote it up. Thanks.
3 Replies
Thanks lbendlin . Yes I tried this previously, but stuck with what values to use for "server name" and "database name" in the Connection string. Because in the SSMS connection, all I need to put in is the Power BI datamart's Connection string (in the form of ".....datamart.fabric.microsoft.com").
Also I had issue with below code.
token_bytes = credential.get_token("https://https://database.windows.net/.default").token.encode("UTF-16-LE")
My initial guess is that PowerBI datamart connection probably needs some specific treatment, comparing to normal Azure SQL Database connection.
Ok, I got confirmation from Microsoft that ADF and Python connection are not supported at the moment. I raised this idea on Microsoft Idea. If you have the same requirement, please help to vote it up. Thanks.
