title: Get only the data I want from a db but keep structure
body: <p>I'm trying to do this on powerbi but I guess it's just basic SQL</p>
  
  <p>I would like to import my data in powerBi but filtering it with some id. Let's take this example. I have db with some companies (table 1). Each compay has building (table2) and each building has employees (table3).
  I would like to import thoses three table but only for a company ( OnePowerBi is about One company, never more). Please notice that each table has the foreign key of the parent one. My schema works well in powerBI</p>
  
  <p>I tried to make SQL query in advanced option ( on power BI you can do some SQL before chossing which table import) but if I do:</p>
  
  <pre><code>select * from companies where idcomp=1
  </code></pre>
  
  <p>It will only import the company table.
  I would like to import all the data of all the tables if thoses data are linked to the selected company ID but keep the structure and not get all the data in a "request" or "table", as an inner join will do. How should I do?</p>