[X]My Assistant

[2ME]

Hi,
I have a query where two dates parameter
When I try to get the data in power bi I don't have an option to view that query (the query doesn't appear among other tables and queries)
And if I removed the dates from where clause I can select the query within power bi
My question, is there any work around to get the query with two dates parameter within power bi?

Thanks in advance for your suggestion and help

[GroverParkGeorge]

I doubt it. I think the best choice will be to do the filtering in Power BI.

[2ME]

How can I set the two dates parameters in power bi?

[MadPiet]

Where is your data coming from? You can filter the data before you load it, or load the data from a query in the source.
if you don't just "Close & Load", you can filter the dataset before it imports it all.

[2ME]

Hi MadPiet
The data comes from access query
"You can filter the data before you load it, or load the data from a query in the source."
I tried to open the query and used the filter before getting the data to power bi .. but the query wasn't there at all to select it

After removing the date parameter the query appeared to select it within power bi

[GroverParkGeorge]

In the Power BI editing interface, load a project and then select the "Data" view for you data sources:

 DataviewPBI.png ( 991bytes )Number of downloads: 0


Select the query you want to filter.

Then apply parameters to it.

 ParamersPBI.png ( 12.25K )Number of downloads: 0


If you need dynamic filtering, you can add filters to the chart displaying the data:

 AddSlicer.png ( 16.33K )Number of downloads: 0


 FiltersinPowerBI.png ( 14.43K )Number of downloads: 0


 FilterSlicerPBI.png ( 9.76K )Number of downloads: 0


 FilterSlicerAppliedPBI.png ( 8.91K )Number of downloads: 0

[2ME]

GroverParkGeorge thank you very much for your help I will give it a try and come back to review the result
Thank you again

[2ME]

Hi MadPiet
"or load the data from a query in the source."
How can I do that?

[MadPiet]

Oh, Guess you can't do that with Access as a source. You can with SQL Server. If you connect to a SQL Server DB, you have an advanced option where you can specify a query to run. (Or even just type in the SQL).

[2ME]

What about creating a temp table and append the query after filter to the temp table?

[GroverParkGeorge]

You could do that, but that means the process always starts on the Access side with the "flush and refill" of the temp table.

I am pretty sure, though, that you can apply your filters in Power BI itself against the table(s) and quer(ies) you need.

[2ME]

GroverParkGeorge

Thank you very much for your help, I used slicer to filter against the queries and it works

thank you again

[GroverParkGeorge]

Congratulations on solving the problem.

Continued success with your project.