Forum Discussion
Power BI Report builder
IN Datasource:snowflake I am getting the corrrect data but i m using same query in report builder i m not getting correct data in visualizations showing irrelevant data .even parameters are correct only . below is the query ........
select
Case (?)
When 'Settlement' Then "SettlementCCY" Else "SalesCCY"
End SalesCCY,
ROW_NUMBER() OVER(ORDER BY
SalesCCY ASC) AS "Row#",
sum("sales_amt_USD") as USD_Sales_amt, sum("sales_amt_EUR") as EUR_Sales_amt,
sum("sales_amt_CCY2") as sales_amt_CCY2, sum("amt_payment_CCY2") amt_payment_CCY2,
sum("am_PaymentLocal") am_PaymentLocal,
sum("am_PaymentUSD") am_PaymentUSD, sum("am_PaymentEUR") am_PaymentEUR,
sum("ExpectedSettlement") ExpectedSettlement
from v_pbi_credit_cards_report v
inner join
(select "sk_AirlineMDM", max("external_user_id") as external_user_id from v_pbi_user_airline
where ((select "in_Internal" from v_pbi_user_airline where
"external_user_id" =(?)) = 0 and "external_user_id"=(?)) or ((select "in_Internal" from v_pbi_user_airline where
"external_user_id" =(?)) = 1 and "sk_AirlineMDM" = (?))
group by "sk_AirlineMDM"
)
b
on v."sk_AirlineMDM" = b."sk_AirlineMDM"
where
Case (?)
When 'Billing' Then "BillingDay"
When 'Sales' Then "SalesDay"
When 'Settlement' Then "settlement_date"
End >=(?)
and
Case (?)
When 'Billing' Then "BillingDay"
When 'Sales' Then "SalesDay"
When 'Settlement' Then "settlement_date"
End <= (?)
and "sk_SettlementSystem" in (SELECT VALUE FROM TABLE (SPLIT_TO_TABLE(?,',')))
group by
SalesCCY
order by sum("sales_amt_USD") desc
1 Reply
can anyone tell solution? why i m getting incorrect data ..there is no wrong in the query then why i m getting incorrect data in report builder? or it is the report builder issue Power BI Report builder
