User Profile
RuthHacche
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Power Query/.net controlled windows not opening in excel
I think I have found my solution. When I work in the office my laptop sits to the left of my screen. At home it sits to the right of my screen. I suspect I did not shut down excel when I last left the office and power query has remained positioned off to the right of my laptop - not visible at home. I used to have this problem with Sage windows. The answer is quite easy 1 Make sure the application is selected (choose it in the taskbar, or use the ALT-TAB keys to select it). 2Type and hold down ALT-SPACE, then type M. (IMPORTANT NOTE: If you are working on a remote desktop or cloud, use ALT-DELETE instead if ALT-SPACE.) 3Your mouse pointer will change to have 4 arrows and you can move the window back into view. I do hope this helps people.2KViews0likes1CommentPower Query/.net controlled windows not opening in excel
No problems until last week. Now when I try and launch power query I just get the loading .net framework notification at the bottom of the screen and excel locks. It totally feels like power query is open - I just cannot see it. Other windows do not work either - eg the contact support windows are just blank - I am sure it has something to do with .Net rather than power query itself. I am on the latest version of office 365. I have uninstalled, reinstalled, repaired, removed Custom XML data, Turned .NET framework 3.5 and 4.8 off. and back on. etc etc. Kicked the laptop. And stroked it. From googling this issue it does seem to appear often enough to be a real issue - but then people reporting it just seem to disappear before any resolution is posted - is this a self resolving issue? Other people in this org do not have same issue. It has been like it for 5 days now and I am close to throwing the whole kit out the window (as you can imagine).Solved1.9KViews0likes2CommentsExpand / collapse columns - in an excel pivot created from GetData PowerBI dataset (channel prev
I have created a pivot from my power BI dataset (using Get data / powerBI dataset - I have a channel preview account ) In a traditional pivot you can expand and collapse data in columns from the header regardless of whether you have already expanded some individual items int he column. In the powerBi dataset based pivot , if you have already manually expanded one or two items (in say columns 3 and 4) you have to go back and collapse everything from the first column and then re-expand whole columns to show all the data. If you collapse the entire field for column 3 (currently part expanded) and then expand all on column 3 it will just go back to your part expansion - not to expand all. Until you collapse all in all the previous columns. Community support over in Power BI think it is designed but would be interested to here from the excel experts - is this expected behaviour?1.1KViews0likes0Comments
Recent Blog Articles
No content to show