Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@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
Could you please export gateway log and share gateway log here?
Regards,
Lydia
We do not have admin access to the gateways in my organisation, but I have asked them if they can send something across to me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |