Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |