Forum Discussion

roopa_123's avatar
roopa_123
Helper I
3 years ago
Solved

IBAN validation using PowerBI

Hi Team,

I have a requirement where I need to validate the IBAN's for different countries are valid or invalid using PowerBI. The source data for the IBAN is coming from the parquet file that is present on the Azure data lake gen2. I need to connect to this particular parquet file and then validate whether the IBAN is valid or not using PowerBI. How can I achieve this? I have tried POC with R script but this script doesn't work for all the countries. 

Any help is much appreciated!

Need Help
Show and Tell
  • roopa_123's avatar
    roopa_123
    3 years ago

    Thanks for your response!
    I've tried other ways of implementing the same rather than using R-script. It works now!

4 Replies

  • roopa_123's avatar
    roopa_123
    Helper I
    3 years ago

    Thanks for your response!
    I've tried other ways of implementing the same rather than using R-script. It works now!

    • roopa_123's avatar
      roopa_123
      Helper I
      3 years ago

      Hi lbendlin 
      Thankyou for the reply! But I am looking at how to make the R script work for all the countries IBAN validation in PowerBI

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        What have you tried and where are you stuck?