Forum Discussion
Problem uploading my model from Service with incremental loading
Good afternoon
I am having trouble loading the model once I have performed and followed the incremental loading steps since the local model of my model (even if it is a premium user category) has exceeded 1GB of model.
https://learn.microsoft.com/es-es/power-bi/connect-data/incremental-refresh-overview
As the documentation says, some parameters should be established so that from the local it only takes into account the day you specify, in my case 2 and from the archive to 3 previous years.
Once all this I have done locally. I have published it and I have taken it to Service, where you have to do a manual reload, so that the model makes its partitions in the Service.
But I am running into a problem in the recharge since it exceeds the courtesy time, throwing this error at me.
I don't know if anyone has been in this similar situation, because I have done all the steps but I have the problem when loading the model.
Thank you very much for any help
14 Replies
Hello Syndicate_Admin
Thank you for reaching out to the Microsoft Community Forum.
The error message indicates that the dataset refresh is timing out due to long-running queries or exceeding the Power BI Service’s resource limits. Since you're working with Incremental Refresh:
Premium capacity allows datasets to exceed 1 GB, but this requires enabling the Large model storage format.
Enable Large Model Storage Format:
Go to the Power BI Service, navigate to the workspace containing the dataset, access Dataset Settings, toggle Large Model Storage Format to On, and click Apply. After enabling, attempt the manual refresh again to see if it resolves the timeout.The timeout likely occurs because the initial refresh in the Service attempts to process all 3 years of historical data to create partitions, which exceeds the refresh time limit (typically 5 hours in Premium, though it can vary).To work around this:
In Power BI Desktop, go to Transform Data > Manage Parameters, temporarily set RangeStart and RangeEnd to a smaller range (e.g., last 1 day), apply the filter to your date column, and republish the dataset to the Power BI Service.
In the Power BI Service, trigger a manual refresh. Since the dataset now contains minimal data, it should complete quickly and establish the partition structure.Once the initial refresh succeeds, adjust the refresh policy to include the full 3 years of historical data.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you!
Good morning
Thank you very much for the answer
Vaya al servicio Power BI, vaya al área de trabajo que contiene el conjunto de datos, acceda a Configuración del conjunto de datos, cambie Formato de almacenamiento de modelo grande a Activado y haga clic en Aplicar. Después de habilitar, intente la actualización manual de nuevo para ver si resuelve el tiempo de espera.Replying to this issue I am in Service and I am going to this screen but I cannot find anywhere Large model storage format, I do not know if I am doing something wrong.
En Power BI Desktop, vaya a Transformar datos > Administrar parámetros, establezca temporalmente RangeStart y RangeEnd en un intervalo menor (por ejemplo, último 1 día), aplique el filtro a la columna de fecha y vuelva a publicar el conjunto de datos en el servicio Power BI.Answering this, I go to the report again and activate the Incremental Update by putting this data
Now I publish it back to service and throw a manual update, once that manual update is finished, I should change the policy where?
"Adjust the update policy to include the full 3 years of historical data."I don't know if I'm following the steps well according to what you say.
I appreciate any help
Thanks a lot
I understand that you have been checking in the Report Settings for the Large Model Storage Format option. As I mentioned in my previous response dataset settings it means in Power BI the Semantic Model was previously known as a Dataset.This setting needs to be enabled at the Semantic Model level rather than in the Report Settings.
Please refer to the reference document below, which provides more detailed information on how to enable this option.Large semantic models in Power BI Premium - Power BI | Microsoft Learn
Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
If this post helpful, kindly mark it as Accept as Solution and Kudos will be appreciated.
Thank you.
Good afternoon
Thank you very much for the message
Following your advice and the documentation, I go to Data model configuration and I get this, not giving me the option to choose Large model storage format.
On the other hand I have the Pro user and not premium, but I deduce that Pro will be better.
I don't understand where I can activate the big data models tab.
Thanks a lot
Based on the screenshot you provided, I see that the Large Model Storage Format option is not available. This feature is only available in Power BI Premium or Premium Per User (PPU) workspaces.
Since you are currently using a Power BI Pro license, the Large Model Storage Format setting will not be accessible. Power BI Pro does not support large semantic models, as this capability is specifically designed for Premium capacities to handle larger datasets efficiently.
If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thank you!
Good
This is my license currently.
On the other hand I would like to know that I am the administrator of Power Bi and the one who prepares reports if any worker wants to view and only view a report should he have some license added or is the free one enough?
Thanks a lot
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Syndicate_Admin
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi Syndicate_Admin
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
