Forum Discussion
Import dataverse data using service principal
Hi ReneSchlegel ,
You are right, the official connector for querying data via TDS ("Dataverse") does not support authentication via service principals. In order to achieve this, you can create a custom connector using the Power Query SDK. However, the documentation does not provide information on whether you can authenticate to the Tabular Data Stream interface using a service principal, or whether you need a different interface.
GitHub - microsoft/DataConnectors: Data Connector SDK and samples for Power Query and Power BI
You can continue to use your PBI Pro license if you don't need some advanced features.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi ReneSchlegel ,
You are right, the official connector for querying data via TDS ("Dataverse") does not support authentication via service principals. In order to achieve this, you can create a custom connector using the Power Query SDK. However, the documentation does not provide information on whether you can authenticate to the Tabular Data Stream interface using a service principal, or whether you need a different interface.
GitHub - microsoft/DataConnectors: Data Connector SDK and samples for Power Query and Power BI
You can continue to use your PBI Pro license if you don't need some advanced features.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thanks a lot!
For now using a custom connector would work. After the summer we want to start using Fabric. With Fabric (or more precise Power Query Online) we are not able to use a custom connector, right? What is the recommanded way to get data from Dataverse to Fabric?
