create report in Power BI using SQL code

[Anonymous]

Hi,

I have developed a code in SQL Server joining 6 tables(inclues left outer join), now I have to develop a report in Power BI using this code by allowing the user to filter the report by dates while running it.

I tried to import the code in Power BI but since its having huge volumes of data iam unable to use this mode.

I also tried to import tables first and created relationships between them but since I am having left outer join this also did not work.

Please suggest a method how to develop a report by letting user to filter by date.

[vanessafvg]

how much data are you trying to import in?     How are you importing the code in?   Can you please share the steps of what you are doing.

[Anonymous]

Its approximately 4 years of data thats the reason the user is using date filter and running the report. One month has 39000 records.

I created code in SQL joing 6 tables as per business requirement, the same I need to develop in Power BI, giving option for user to select date.

[vanessafvg · Accepted solution]

are you able to share , some dummy data?  best thing to do is put your sql query in the advanced section, expand and paste, have you done that?

you can also create parameters for the date, 

this article gives a good explanation.  

https://blog.crossjoin.co.uk/2016/12/11/passing-parameters-to-sql-queries-with-value-nativequery-in-...

If you have specific questions please feel free to ask.