Forum Discussion
Importing Table-Valued Function in SQL to Power BI
I tried to re-pro the issue from my end and it is showing that static, no option to change the input parameters.
I tried two ways,
1. After selecting the function, passed the input parameter values before loading.
2. By using the "Advanced Options", copied the function select statement.
SELECT * FROM DBO.EMPHIREDATE('01/01/1981','12/31/1981')
Hoping that this is be design now, Please post your idea in "Power BI Ideas Forum Page".
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?
I tried to re-pro the issue from my end and it is showing that static, no option to change the input parameters.
I tried two ways,
1. After selecting the function, passed the input parameter values before loading.
2. By using the "Advanced Options", copied the function select statement.
SELECT * FROM DBO.EMPHIREDATE('01/01/1981','12/31/1981')
Hoping that this is be design now, Please post your idea in "Power BI Ideas Forum Page".
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?
Thanks for checking venal. I'll probably replicate how the table-valued function is constructed in SQL to Power BI.
Thank you again for your support.Has this issue been fixed? I am at a loss as to why this and others have been marked as "solved" with no viable solutions noted. 😕
