Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
PraprotnikT
New Member

Power BI Desktop & On Premise gateway crashing with Sep 2018 update

I am having big issues that firstly started with On Premise gateway September 2018 update installation.

I have not done any changes to the pbix files, the extraction was the same and after the installation it started crashing with "Out of memory errors" in the logs. Looking at the server resources I can confirm there is plenty of memory available so it is not a resource problem.

 

At this point I had PBI desktop Aug 2018 installed on the same computer. I was able to open it and run full extraction of data without issues.

I then installed PBI September 2018 update, opened the same pbix file. PBI desktop starts giving me Java errors like "Out of memory on line 2", "jquery is undefined". I do not even have to click anything, I just wait 30 seconds and it starts giving this.

I also tryed removing all the reports but I get the same issue.

 

The only thing that solved it is installing back the August 2018 PBI desktop version. 

I could not believe it so I tryed the same thing on a another computer and I get the same issues.

 

My source files are 5 XML files with up to 12 MB size per file. I am doing some merging and transformation. Nothing really fancy.

 

I am assuming after all the above debugging that on-prem gateway has the same issues as PBI for sept 2018 release. So finding the on-prem gateway from Aug 2018 I could confirm this, however I could not find it anywhere.

 

Anyone else having similar issues? Does anyone have on-prem gateway installer from Aug 2018 ?

 

Thanks

Tomaz

 

 

1 ACCEPTED SOLUTION
splaxi
Frequent Visitor

Hi,

 

Several others have been facing issues with the Data Gateway releases in september.

 

You can read more about all our findings here

 

I was lucky enough to get in contact with a person that had a download of the august laying around. You can download it here

 

The link will work for 6 days from now.

View solution in original post

6 REPLIES 6
Eric
Advocate I
Advocate I

We are having numerous issues with the September update to the on premises gateway.  We have more than a dozen scheduled routines running daily and they ran without a hitch for months until we updated the gateway with the September release and now we have a constant series of problems.  Routines that ran in 20 minutes before are now timing out after two hours.  We simply did not have these issues before.  I'm glad to know that we are not alone.  We've been racking our brains trying to determine what changed and the only thing we can find is that we updated the gateway and PBI desktop.  Not sure which one is causing the problem because we have started getting out of memory errors in PBI Desktop too.  Again, none of these things happened before we updated.

Hey - seems you are not alone by far.
The only thing that worked for us was rolling back the update of desktop and gateway. They mist have some shared components that are bugged.

I wonder what MS is saying about this.
v-frfei-msft
Community Support
Community Support

Hi @PraprotnikT,

 

Could yuo please delete the merge table and import your data to the power BI desktop and try again? If the issue still occur, kindly share your M code to me.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

I am not sure how to do that in PBI... Sorry noob here...

 

I am running a PBI desktop august release because september release crashes 30 seconds after I open my pbix file even without loading any data from source files. I can just leave it there and it will crash.

 

splaxi
Frequent Visitor

Hi,

 

Several others have been facing issues with the Data Gateway releases in september.

 

You can read more about all our findings here

 

I was lucky enough to get in contact with a person that had a download of the august laying around. You can download it here

 

The link will work for 6 days from now.

Great job, thanks a lot. Was looking for the old installer everywhere.

I will answer support first then put back old version.

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.