Forum Discussion

MRad's avatar
MRad
Regular Visitor
2 years ago
Solved

Overload resolution failed because no accessible 'IIf' accepts this number of arguments.

Hello everyone: I am building Paginated Report in PBI and would like to have a Dynamic Report Title.  All my components work fine but put together gives an error stating that IIF cannot take too man...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from hackcrr , allow me to provide a supplement to the approach you gave:
    Hi,MRad 

    Regarding the issue you raised, my solution is as follows:

     According to the screenshot of your error report, the main reason is that the citation isbank function can not be called, the reason for this situation is because you use the function of DAX in powerquery, in Power Query M language, there is no direct ISBLANK function, but you can use other methods to determine whether it is empty or not:
    1. Table.IsEmpty().To check if the table is empty, here is a simple output:

    Below are links to the relevant documentation:

     Table.IsEmpty - PowerQuery M | Microsoft Learn
    2.List.IsEmpty().Checks if the column is empty, here is a simple output:

    Below are links to the relevant documentation:

    List.IsEmpty - PowerQuery M | Microsoft Learn

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MRad's avatar
MRad
Regular Visitor
2 years ago

Thank you hackcrr for taking the time to respond.  I am sorry if I

did not mention the report is in Power BI Report builder and running your code I got this error:ISBLANK is not declared

 

 

Appreciate your help

MRad's avatar
MRad
Regular Visitor
2 years ago

Any chance anyone could shed more light on this, would very much appreciate it, still have not resolve it, thank you

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks for the reply from hackcrr , allow me to provide a supplement to the approach you gave:
    Hi,MRad 

    Regarding the issue you raised, my solution is as follows:

     According to the screenshot of your error report, the main reason is that the citation isbank function can not be called, the reason for this situation is because you use the function of DAX in powerquery, in Power Query M language, there is no direct ISBLANK function, but you can use other methods to determine whether it is empty or not:
    1. Table.IsEmpty().To check if the table is empty, here is a simple output:

    Below are links to the relevant documentation:

     Table.IsEmpty - PowerQuery M | Microsoft Learn
    2.List.IsEmpty().Checks if the column is empty, here is a simple output:

    Below are links to the relevant documentation:

    List.IsEmpty - PowerQuery M | Microsoft Learn

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.