Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

model.SaveChanges() hangs when looping over several small partitions #92

Open
casperlehmann opened this issue Feb 12, 2021 · 0 comments

Comments

@casperlehmann
Copy link

casperlehmann commented Feb 12, 2021

I am running a loop over all the partitions I need to refresh. partition.RequestRefresh and model.SaveChanges() do the job, except every once every ten calls model.SaveChanges() just hangs. No error or anything. I am repeatedly testing on the same partitions, and it's essentially random which ones fail. The partitions are on the smaller side (it takes all but five minutes when it works), but I am currently waiting for a command that has run for 2.5 hours. What can I do to debug this?

Console.WriteLine("processPartitionInTable: Requesting refresh...");
partition.RequestRefresh(type: Microsoft.AnalysisServices.Tabular.RefreshType.Full);
Console.WriteLine("processPartitionInTable: Saving changes...");
model.SaveChanges();
Console.WriteLine("processPartitionInTable: Done");

I am running on a P1 sku Power BI instance. And as I said, these are small partitions at about 5-10 million row each. I don't think much else is happening on the server while I do this work.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant