Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
Thanks for your response!
I've tried other ways of implementing the same rather than using R-script. It works now!
Thanks for your response!
I've tried other ways of implementing the same rather than using R-script. It works now!
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?
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |