Forum Discussion
Power BI Desktop July 2016 bug
I have applied the July 2016 update (PBIDesktop_x64 2.37.4464.361). Now I am no longer able to edit my DAX queries through Query Editor. When I double click on "Source" in the Query Editor, the Query Editor screen just hangs.
Is anyone facing the same issue?
- Hi all, we have released a QFE of the July update that addresses this problem. Please redownload the program and try again. Thanks!
42 Replies
I've ran into several problems after installing the July update.
Basic queries are taking forever to load.
The desktop app in general has become very slow and sometimes unresponsive, especially when working in the query editor.
The "Export to Excel" feature has some serious limitations, which was not there before.
After sending a frown, Microsoft indicated that they are publishing a new update ASAP that will fix all of the bugs. Hopefully this is soon.
- Hi all, we have released a QFE of the July update that addresses this problem. Please redownload the program and try again. Thanks!
Good to go on my end! Thanks!
Same here - seems to be working for me after the update. Thank you!
Even after update I am getting the error. Please check the error info below.
Error Message:
Failed to save modifications to the server. Error returned: 'The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.
'.Stack Trace:
Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.
'.
I'm having a very similar problem. I downloaded the new version yesterday morning and was able to work most of the day then all of a sudden in the middle of the afternoon, it froze on me. Turns out it freezes when I go to Get Data or edit an existing query.
Which type of data source are your using? Import data or dorectly query? Please provide us the steps to reproduce this issue, so that we can make further analysis.
Thanks for the quick response Charlie. I cannot access SQL Server. Power BI freezes after I perform these two actions:
1. Get Data (this happens even on a brand new Power BI file)
i. Click Get Data
ii. Click on SQL Server
iii. App freezes
2. Edit Query (queries run against SQL Server)
i. Right click on an existing query and click Edit Query
ii. Click on the gear for the source under Query Properties
iii. App freezes
I've been able to do plenty of work with visuals and creating measures. Just creating or editing queries appears to be the issue.
Having the same issue - when I click the "Source" button in Edit Queries, it freezes, and I have to use the task manager to get rid of it.
Is there an ETA on when a fix will be provided?
I have tested the issue at my side, and it is OK for me to open the source settings.
Recommended troubleshootings are:1. Enable the trace log and reproduce the steps (File ->Options and Settings -> Options -> Global-> Diagnostics), then open the trace log path, find the newly created trace log and see if any helpful information could be logged, or you may consider upload it into OneDrive and post the shared link in your next post, we will help to take a check;
2. Find the PowerBIDesktop install Media, double click it to perform a repair or a re-install.Regards,
Charlie Liao
I have saved the file on the path below:
hxxps://1drv.ms/u/s!AuBU-ITvrxqMh2n7iWUUTWvp-n8T
I am not even able to make a new connection to Analysis Services. The whole Power BI Desktop just becomes responseless and none of the buttons can be clicked once Analysis Services source is selected
Hey Charlie,
This is my log of the Crash. It occures exactly when I try to edit queries in no matter what way uploaded data: GA, Excel, CSV
I have a similar issue with PowerBI Desktop. I tried repair from isntallation media. Does not seem to work.
When i go to "get data" and open SQL Server or any data source for that matter, the application freezes.
For anyone else who experiences this bug and is waiting for a fix, I was able to edit queries in the Advanced Editor screen so I could keep working. Steps to get here are Query Editor -> View -> Advanced Editor.
I downloaded this version on my new laptop. It doesn't load any data, nor does it let me create a table and load it to the query.
Pretty disappointed as I need access to PBI urgently.
I've been able to load data to Power BI with Excel using Power Query to retrieve data. This should allow to continue making visuals and measures and when a fix is implemented, just need to modify the source and I think things SHOULD be just flow.
To folks who are running into this issue, what OS are you on, is it x64 or x86 PBI desktop, and what screen DPI (scaling factor) is involved?
I'm running on Windows 7 and 64 bit. Could you be more specific on the DPI? I'm not sure how to link the DPI to the fact that we can't retrieve data. I keep hitting walls with getting One Drive installed. Is there a person I can email my trace file to?
- After looking at multiple reports of this and looking at some of the traces, I believe the get data dialog is there on the screen, just not visible. This makes the app appear to be hang, but you can unblock it pressing ESC.
I don't know what causes the dialog to not visible, hence the DPI question
