Forum Discussion
Loading already created dataware house into Power BI
Hi,
This may be a simple question but I couldn't find an explicit answer online. If I already built my datawarehouse in SQL and the tables are already connected by keys and have relationships, is there a way to connect to that data without having to import each table alone and recreating the relationships? Thanks!
israabuhasna still, you have to create a model in Power BI except if you are using Live connection to SSAS or Power BI service as dat source
4 Replies
- parry2k
Super User
israabuhasna you have to recrate the relationship in power bi after you loaded teh tables from data warehouse.
- israabuhasna
Helper I
What if we create a direct query to Azure SQL Database?
- parry2k
Super User
israabuhasna still, you have to create a model in Power BI except if you are using Live connection to SSAS or Power BI service as dat source