Forum Discussion
Power BI Service - Parameter based query doesn't work but work in Power BI Desktop
I have used the below custom parameter based query to filter the direct query dataset based on slicer values:
let
Source = Oracle.Database(DataSource),
Step= Value.NativeQuery(Source,"SELECT * FROM SB.FACT WHERE TXID='"&T&"' or INSID = '"&I&"'
")
in
Step
It seems to work perfectly fine in Power BI Desktop but doesn't work in Power BI Service
Desktop: Returns results based on TXID and INSID slicer value
Service : Visual has exceeded available resources.
No Replies