Forum Discussion
RDL using Power BI Dataset in Service
Hi All, we're doing a PoC of PBRS. I've created a quick & dirty RDL using Power BI Report Builder (v15.0.1380.0) that uses a Power BI Dataset in Service. We have a Premium tenant. While the RDL ru...
Thanks!! the solution worked.
but i have an issue with using named parameters in report builder. do you have any solutions here ?
EVALUATE
VAR _TempTable=
SUMMARIZECOLUMNS (
'INVOICE_ITEM'[COMPANY_ID],
'INVOICE_ITEM'[INVOICE_ID],
FILTER (
VALUES ( 'INVOICE_ITEM'[CUSTOMER_ACCOUNT_ID] ),
( 'INVOICE_ITEM'[CUSTOMER_ACCOUNT_ID] = VALUE(@CustomerNo) )
)
)
RETURN
SELECTCOLUMNS(_TempTable,"COMPANY_ID", [COMPANY_ID],
"INVOICE_ID", [INVOICE_ID]
)
ORDER BY [INVOICE_DATE] DESC
I don't have a direct solution as I didnt go very far after just getting it to work. If I were takleing that though, I would try and push what I could of that into the published data source.