Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ihebc
Frequent 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 database)

- tables and relationship must be define in code of the connector.

 

the object of my request is to protect my job : i'm developping a kind of data model using  SQL views and procedures so the obective is to protect my job

 

I was find some exemple in internet but i can't find the best way to solve my problem.

 

Thank you

2 REPLIES 2
v-xuding-msft
Community Support
Community 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.

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.

@v-xuding-mfst thank you,
But the probleme here is that my customers use Power BI Report Server, so i can't use dataflows 🤔.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.