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?
Solved! Go to Solution.
I have found a setup where this issue is showing up, so I have enough to go investigate this issue with.
I'll update this thread once the problem is located and a fix is found
I am not able to open 20MB PBIX file after update to July release and it is giving memory error. Worst part if we are not keeping June MSI file, you can not revert to previous version. PowerBI portal always gives latest version of release.
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?
@pqian I tried ESC when the app hangs but it doesn't do anything.
As for the DPI, are you wanting the resolution of the page in Power BI or the resolution of my screen or something different?
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.
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.
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'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.
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.
I am having the same freezing issues when clicking into Get Data. When I click on recent sources and click the source I need, it doesn't load. I then try and create a new source and it freezes when I try to open the OData option.
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.
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.
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
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!