Power BI Desktop SQL query builder

[Anonymous]

Hi All,

I need some help. I am working On power with SQL server. Having some issues would be great help if anyone can suggest some solutions

I am tying to load a table from a database using import query in power bi desktop. Query like db.abc_xyz '2017-03-01', '2017-03-31' now this query return all data between those date ranges. Which work for me. But now I want to extract for 1st April, it create new query and table everytime. Is there any way I can append data beneath the old one. I mean everytime I refresh the power bi new data must append in the particular table.

Also is there any way I can provide user interface which may ask for date range every time I run data extraction query

[v-qiuyu-msft]

Hi @Anonymous,

Assume you write the T-SQL query when you get data from SQL Server database to filter data between date range '2017-03-01', '2017-03-31', you can open Query Editor -> Advanced Editor, then modify the T_SQL query to include 1st April (eg: replace "2017-3-31" as "2017-4-1")

In Power BI desktop, there is Query Parameter feature for us to filter data dynamically. You can create two parameters "StartDate" and "EndDate", then use those two parameters to filter date column. For more information, see: Deep Dive into Query Parameters and Power BI Templates .

Best Regards,
Qiuyun Yu 

[Anonymous]

Thanks v-qiuyu-MSFT,

But does it will replace all data in the query or just append 1st Apr data. I don't want duplicates data.

[v-qiuyu-msft · Accepted solution]

Modify the T-SQL query will return one additional row which contains date "2017-4-1" compares to the original result.

You can try those two ways in your desktop.

Best Regards,
Qiuyun Yu