IBAN validation using PowerBI

[roopa_123]

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!

[roopa_123 · Accepted solution]

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

[lbendlin]

Power BI can ingest Parquet files directly.

[roopa_123]

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]

What have you tried and where are you stuck?