I have created transactional replication from my Azure VM to SQL Database where only x amount of tables were needed but then Power BI was used to connect to SQL Database for analysis - worth sharing my experiences on setting it up? please let me know.