Forum Discussion

markefrody's avatar
markefrody
Post Patron
6 years ago
Solved

Importing Table-Valued Function in SQL to Power BI

Hi,   I have table-valued function in SQL that I wish to import in Power BI. Problem is I cannot directly import the entire table-valued function to Power BI. It prompts me to input the start and e...
Need Help
  • venal's avatar
    venal
    6 years ago

    markefrody 

    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?