Forum Discussion

truman99's avatar
truman99
Regular Visitor
4 years ago

Passing Paramaters

Using drill through reporting, I'm passing a domain and date from the source report to the drill through report to limit the number of records returned. The domain and date is seen, but not used.

 

You can see in this screen shot (below) that the domain is the same all the way down and it is the one that I passed. So that is good.

The Lookup date is the same all the way down and it is also the one that I passed. So that is good.

But then I put the Full Date in and you can see that PowerBI is looking at all dates and not just the one I'm passing. This is why I keep getting the error of too many records returned.

 

I hit the db directly in SSMS and my SQL returns 1,291 rows for the domain and Lookup Date passed.


 

Need Help

6 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    4 years ago

    truman99 

    Need to understand the requriement of Fulldate becausae this is voilating the Drill thru condition I think

    • truman99's avatar
      truman99
      Regular Visitor
      4 years ago

      VijayPnot sure if this answers your question, but I'm passing the domain and date to limit the number of results I pull back.

      So I have domain and full date on the Drill-through fields section under the Visualizations. These are the same fields on the Source report.

      In that screen shot I showed, I just have the Full Date column to show the issue. Here is another screen shot without it showing that I'm getting the right Domain and Date. It is only when I add another dimension that it seems to ignore the date that I'm passing and instead it tries to grab a result for all dates. It is like PBI sees my parameters but then ignores one of the two of them.

    • truman99's avatar
      truman99
      Regular Visitor
      4 years ago

      Thanks v-easonf-msft -- that's the thing, I'm passing two filters and the visualization is seeing them, I've confirmed using variables and Return. The weird part is that PBI sees the Domain filter and the Date filter but then only uses the Domain filter. It ignores the Date filter and instead tries to pull records for ALL dates which is throwing me over the limit.

      Do you know why PBI would see a parameter and not use it?

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, truman99 

        Not fully sure what you want. Did you mean that field ‘look up date’ in the drill through pane is not filtered?

        What you mean by 'using variables and Return'? Can you show relevant screenshots about the drill through pane and all the fields used in the current target page?

         

        Best Regards,

        Community Support Team _ Eason