How to import two tables from a single SQL query in power bi desktop

[Haripriya_9]

Hi Guys ,

I have single SQL query which is resulted in two tables  and while am trying to import the query  in power bi desktop ,it is loading the first table but not the second table.  

Can anyone suggest how to achieve this.

Thanks in advance.

[Idrissshatila]

Hello @Haripriya_9 ,

You could create two seperate views for each table and import them into power bi.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Haripriya_9]

Hello @Idrissshatila ,

Thank you for response. But , we cannot create two seperate views for each table since it is interlinked