I've tried this but this is all the data I get. If i click into data->list, I get total data for my facebook ads - there is no day-wise data. Is there any way to resolve this to have into load into power bi as a table and day-wise.
Glad to hear that it also works for you. I've requeste website purchases on Github.
What I do to calculate ROAS, is to find the revenue on the matching campaign in my raw data. This ROAS is far lower than the ROAS that you can calculate on Facebook data alone. Cost per user is also a good benchmark to cost per click when monitoring campaigns.