Forum Discussion

MarcusClaudius's avatar
MarcusClaudius
Regular Visitor
7 years ago
Solved

Directly linking a TSQL Query into Power BI

To all

 

We have a data source that is big beyond belief. Hence I have written an SQL Query that effectively acts as a considation tool. Thus instead of millions of rows, I'm only looking at 200,000.

However, Power BI does not seem to have a way of letting me link to the query directly. Yes it will let me link to the initial tables, but as prior mentioned. They are too large.

So is there a way to link directly to the Query?

 

Thanks

 

Mark Taylor

Need Help

3 Replies

    • MarcusClaudius's avatar
      MarcusClaudius
      Regular Visitor
      7 years ago

      Thank you so much

       

      Worked first time

       

      Now, onwards and upwards. I've got a report suite to build.

       

      Thanks again

       

      Mark

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    Yes, when you connect to a SQL Server, click on Advanced. There you can paste in SQL code. It does allow you to use EXEC to execute a stored query.