Direct query questions

[abehrmann]

 I am in the process of switching a operation software they have proposed using direct query from a sql database for my data needs. 

This is the diagram they have supplied me with to explain how they will provide me with the data. 

I have limited database knowlege, can someone explain this to me

Also if im using direct query do i need to set up my own sqldatabase or can i connect directly to the distrubution database? 

[abehrmann · Accepted solution]

https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-re...

This link explains the process that our data is being pushed, 

Is a sql database required or can i connect direct query to the distributor?

Thanks 

[abehrmann · Accepted solution]

https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-re...

This link explains the process that our data is being pushed, 

Is a sql database required or can i connect direct query to the distributor?

Thanks 

[Anonymous · Accepted solution]

@abehrmann,

Do you have read access to the distribution database in the distributor? If you have, you can directly connect to the distribution database in Power BI Desktop using DirectQuery mode and create report in Power BI.

Regards,
Lydia