How to connect Power BI to Source Link?

I can't see a connector for Source Link. 

If you need near-real time then a good way to do that is to make a datawarehouse/lakehouse within Fabric and then bring in the data sourcelink. You could look to see if you're able to push changes from sourcelink into the warehouse/lakehouse and if you are - then you can set up a directlake connection to the lakehouse or directquery to the data warehouse and your data will be near real time or real time. 

There's alot of different ways to do this but I can't think of any ones, which won't require some data engineering skills. If you somehow find that the connector does exist though (even through an odbc connection/driver), then I'd suggest going with that approach and seeing if the connector supports direct query. 

One other thing to think about is that if you're trying to drive actions from the CRM things, which are happening - Power Automate might be more appropriate to give people notifications to drive that behaviour. 

Hi JamieC66, 

I don't think there is a native connector for Source Link. 

Is this a cloud hosted CRM or is it hosted on prem? If it's hosted on prem and you can get access, you can probably connect power bi directly to the database that the CRM sits on. 

Otherwise, a common pattern I see used is scheduling exports from the CRM and ingesting those into a database (or a fabric lakehouse/warehouse) and then have your reporting sit on top of that. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Hi JamieC66,

I would also take a moment to thank tayloramy , pbiuseruk  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.