Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone, I have a model, with 5 source : - One DB - 4 Excel/Csv files on my computer i'm trying to add another datatable from one of the excel files but it seems my model fails to connect to it i tried with a fresh new model and it works so i assume it come from my original model. It's just stuck on this part and it never load : The file has less than 100 row and only two columns... My biggest table is 2M rows and it's from the DB. Any idea ?
HI @Anonymous ,
Have you got auto-detect relationships ON in power bi?
Also, can you share your existing data model without this new source?
Thanks,
Pragati