Forum Discussion

zhuowei's avatar
zhuowei
Frequent Visitor
8 years ago

How to pick a date and retrieve the result from Azure SQL

Hello, I'm new to the Power BI. Is it possible in Power bI to build a report where I can pick a date (just as what I do in the power query editor) and get the result/graphs of that date? The data ...
Need Help
zhuowei's avatar
zhuowei
Frequent Visitor
8 years ago

Hello Jessica, thanks for your reply.

I have tried the slicer. I could get the graph of one specific date (for example 13/07/2018) after I loaded the data to PowerBI.

 



But when I select another date, for example 05/07/2018, there is no graph showing up since I haven't loaded the data of 05/07/2018 to PowerBI. What I want to achieve is: the user select a date on the report, then the PowerBI can automatically retrieve the data from Azure SQL. The user will get the relevant graphs without the need to load the data first. Do you have the idea on this issue? Thank you.

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

From the screenshot, I think you are using Import mode in Power BI for connecting data source. In Import mode, Power BI makes a copy of data from source server and stores the data in local. All reports are generated based on the local data, not from the orignial data source. 

 

If you want PowerBI do analysis based on live data retrieve from Azure SQL, you need to use DirectQuery mode to connect Azure SQL. You can find details regarding Import mode and DirectQuery from the following doc

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about