Directly linking a TSQL Query into Power BI

[MarcusClaudius]

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

[v-frfei-msft · Accepted solution]

Hi @MarcusClaudius,

Actually you can query what you want by entering your sql  code here.

Regards,

Frank

[MarcusClaudius]

Thank you so much

Worked first time

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

Thanks again

Mark

[Greg_Deckler]

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.