cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PraprotnikT Frequent Visitor
Frequent Visitor

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

Accepted Solutions
splaxi Frequent Visitor
Frequent Visitor

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

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.

6 REPLIES 6
splaxi Frequent Visitor
Frequent Visitor

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

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.

Community Support Team
Community Support Team

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

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 other members find it more quickly.
PraprotnikT Frequent Visitor
Frequent Visitor

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

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

I will answer support first then put back old version.

 

PraprotnikT Frequent Visitor
Frequent Visitor

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

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.

 

Eric Regular Visitor
Regular Visitor

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

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.

PraprotnikT Frequent Visitor
Frequent Visitor

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

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.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 27 members 752 guests
Please welcome our newest community members: