Forum Discussion
ihebc
6 years agoFrequent Visitor
Custom connector to SQL Server
Hello, I want to create a custom connector to SQL Server. The connector has some proprieties : - Connect only to a specific database (the end user will have not access to choose the server and the...
v-xuding-msft
6 years agoCommunity Support
Hi ihebc ,
Maybe you could try to connect SQL Server with dataflows. You could choose the server and the database. The users can connect to the tables to create their own reports but have no direct access to the data source. Here is the document you could learn from.
Self-service data prep in Power BI
If you only want to create a custom connector, I have no experience for it. Hope others can give you some advices.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
ihebc
6 years agoFrequent Visitor
@v-xuding-mfst thank you,
But the probleme here is that my customers use Power BI Report Server, so i can't use dataflows 🤔.
But the probleme here is that my customers use Power BI Report Server, so i can't use dataflows 🤔.