Forum Discussion
Dataset and tranformations...cannot refresh on web service
JamesRLUK,
How many rows and columns in each of the Excel file? What is the size of your PBIX file? What detailed error message do you get when refreshing data in Power BI Desktop and Power BI Service? Complex data model and multiple transform steps in Power BI Desktop may eat a large amount of memory during the refresh and cause the crash problem. In your scenario, it is recommended to import required columns and rows into Power BI.
In addition, please make sure that you are using latest version of Power BI Desktop and Power BI gateway.
Regards,
Lydia
The problem is I have hundreds of thousands of rows combined and 128 columns at base and by unpivotting etc I add one new column and 5 rows per initial entry...I’m asking a lot of power bi I know, currently I have 2 options I’m aware of;
1. transform in azure and load in that way (but delays my due date of the required report significantly)
2. Transform the data pre load but increasing the file size of the excels I do load into power bi
I am having to load my 10 files one at a time this week in desktop to see if it allows it and of not at which point it times out and has a ‘heart attack’ as I’ve been telling my end users
Could you please export gateway log and share gateway log here?
Regards,
LydiaWe do not have admin access to the gateways in my organisation, but I have asked them if they can send something across to me.