This is important to analyze some issues in detail, since
- the .csv export can produce some wierd and wrong formats / can't be trusted IMO
- the amount of data is limited for copy and paste
- the way through DAX Studio is not as convenient
It requires the info wich port is currently used by PBI Desktop. This is folder/file where the non-app version stores it: C:\Users\User Name\AppData\Local\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\AnalysisServicesWorkspace1026659202\Data\msmdsrv.port.txt
Unfortunately the following location should be the place the app-version stores the correspondent file, but the folder is empty. C:\Users\User Name\AppData\Local\Packages\Microsoft.MicrosoftPowerBIDesktop_8wekyb3d8bbwe\LocalCache\Local\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces
Searching C: for msmdsrv.port.txt didn't show me a second msmdsrv.port.txt....
Since from reading several posts I understood, that the versions should be identical, I hope I am mising something.
Does anyone have the APP Version + I able to locate the msmdsrv.port.txt?
I originally got this tool from @MattAllington site but the location of these files seems to have moved. I had to modify the VBA to find the fie location to...
' developed by Matt Allington from http://exceleratorbi.com.au
user = Environ("LOCALAPPDATA")
UserPath = user & "\Microsoft\Power BI Desktop SSRS\AnalysisServicesWorkspaces"
Sheets("Connection").Range("B2") = UserPath
I also find it handy to filter the workspaces to just the most recent one by changing the Power Query code. This saves having to clean up residual workspaces.
For everyone using the Store App and missing the AnalysisServicesWorkspace folder again after the 2018 October update: it can now be found under C:\Users\%USERNAME%\Microsoft\Power BI Desktop Store App\AnalysisServicesWorkspaces.
For Matt's great Excel template to work after the update, open the Visual Basic editor in Excel and update the UpdateUserPath() sub in Module2 like this:
Change this line: user = Environ("LOCALAPPDATA") To: user = Environ("HOMEDRIVE") & Environ("HOMEPATH") Change this line: UserPath = user & "\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces" To: UserPath = user & "\Microsoft\Power BI Desktop Store App\AnalysisServicesWorkspaces"