Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
roopa_123
Helper I
Helper I

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!

1 ACCEPTED SOLUTION
roopa_123
Helper I
Helper I

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

View solution in original post

4 REPLIES 4
roopa_123
Helper I
Helper I

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

lbendlin
Super User
Super User

Power BI can ingest Parquet files directly.

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

What have you tried and where are you stuck?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.