microsoft / azure-synapse-solution-accelerator-financial-analytics-customer-revenue-growth-factor Goto Github PK

Hello. Thank you for creating the Financial Analytics Accelerator. I've run into a "AnalysisException:" when executing Cell 24 in the Feature Engineering notebook. Is there additional code or parameters that developers such as myself need to add to the preceeding cells?
Cell24ErrorOutput.txt

I was trying to spin this up in my environment and found that the instructions provided are incomplete and/or unclear in some areas.

Fpor instance in step 2 Storage Account permissions, I found I needed to also import the 6 - PBI Data Model notebook as it is needed for Step 5.

And there is instruction to skip to step 8, but there is no step 8 in the documentation.

In notebook 4, right at the bottom, the model metrics and important features are being saved to the ADLS:

important_features.write.format("delta").mode("overwrite").option("overwriteSchema", "true").save(f"abfss://{file_system_name}" + "@"+ f"{data_lake_account_name}.dfs.core.windows.net/important_features/important_features")
model_metrics.write.format("delta").mode("overwrite").option("overwriteSchema", "true").save(f"abfss://{file_system_name}" + "@"+ f"{data_lake_account_name}.dfs.core.windows.net/model_metrics/model_metrics")

However in the PBI report, the datasource is looking to the /source/reporting/important_features and /source/reporting/model_metrics folders.

So when changing the datasource to point to our ADLS, the report still doesn't work unless we either point the datasource to the folders indicated by the code, or the notebook code is updated to write the files out to the reporting subfolder...