web application with postgresql function parameters passing dynamic dates in to power bi

[Anonymous]

Hi

Front end web application we have start and end date values providing statically through back end postgresql . When we connect to direct query to power bi, static dates should be kept in dynamic dates. How to do it?

Requirement:

1. created postgresql function

create function get_item(id int, startdate date, enddate date)

Returns table( ......) as

Begin

--------

end

2. execute function

select * from get_item(123, '20-12-2017', '25-12-2017')

same executed function copied and paste it in power bi statically, its working fine.

when we pass dynamic dates, it is throughing an error.

Data source error: columns "id" does not exist

can you please assit it?

Thanks

kunuthuri

[v-piga-msft]

Hi @Anonymous，

It seems that you want to pass dynamic dates in to power bi from postgresql database.

There is a similar video about SQL Server database may help you.

Best Regards,

Cherry

[Anonymous]

Hi,

I tried to use the parameter in the same way that has been explained in video that you guided to other person, but I got the error as shown below:

Here is the screen shot that shows you how I created the date parameter:

Could you please suggest me a solution. Thank you

Thanks,

Shanmuga