Forum Discussion
Couldn't load the data for this visual Error
I ended up creating a measure in the Bank DB for the mortgage loan total amount. That seemed to solution my problem of erroring out due to lack of memory. Adding fields from either table is snappier.
That's what I suspected. When you just jam a bunch of columns together it isn't sure what to do with them. You need something to tell it how you want to aggreagate things and then it works smoothly. Honestly you're not really using Power BI until you start writing a few measures in my opinion.
My appologies - I dont have data sets I am able to share.
I ended up creating a measure in the Bank DB for the mortgage loan total amount. That seemed to solution my problem of erroring out due to lack of memory. Adding fields from either table is snappier.
That's what I suspected. When you just jam a bunch of columns together it isn't sure what to do with them. You need something to tell it how you want to aggreagate things and then it works smoothly. Honestly you're not really using Power BI until you start writing a few measures in my opinion.
Thanks again for all your assistance.