I have a salesforce report with three objects connected, email, cases, accounts.
My report wont refresh within power bi services (There was an error when processing the data in the dataset.) When I try to refresh thru desktop app I get an out of memory error and it wont refresh. We are on our third year with salesfroce. The report is aprox 580MB, pretty large.
My power query is very simple and I am doing all my calcs in DAX to minimize the query.
Is there a work around for this? I assume the memory error in the desktop refresh is due to my computer, but the power bi service refresh fail started the exact same time as my memory error starter.
Another question I have: If I create a report for each year, will I be able to setup a report that uses multiple different PBI reports (one for each year) so I can comiple trends over year?
The main purpose of my salesforce report is to report yearly trends (month over month, quarter over quarter etc.) and response times and I really need to be able to compare at least three year trends at the minimum for my executive reporting.
