m-kovalsky / reportanalyzer Goto Github PK

Does the report analyzer store the analysis logs ?
Are the analysis logs / company data visible to the vendor?

Is your feature request related to a problem? Please describe.
Is there an command line interface?

Describe the solution you'd like
If I have an CLI then I can use it with powershell and use it with devops.

Describe alternatives you've considered
The alternative is to use the script in tabular editor cli.

Describe the bug
Followed the instructions in https://github.com/m-kovalsky/ReportAnalyzer, I downloaded and installed Report Analyzer, but in Step 5, I selected the folder which contains both Power BI desktop and Performance Analyzer file, it pop out a window says :"Must select a folder with a Power BI Desktop or Power BI Template file."

To Reproduce
Steps to reproduce the behavior:

1. Go to 'https://github.com/m-kovalsky/ReportAnalyzer'
2. Follow the instructions, download and install Report Analyzer
   3.Open Report Analyzer, select the folder which contains both Power BI desktop and Performance Analyzer file
3. See error 'Must select a folder with a Power BI Desktop or Power BI Template file.'

Expected behavior
Could use Report Analyzer normally.

Screenshots
If applicable, add screenshots to help explain your problem.

Version Number (please complete the following information):

• Version [Report Analyzer 1.6.0]
• Version [Power BI 2.107.841.0 64-bit (July 2022)]

Additional context

Add any other context about the problem here.

Describe the bug
When I try to open the program nothing happens,
When I go back to 1.1 then it works again.

To Reproduce
Steps to reproduce the behavior:

1. Open/start the program or .exe

Expected behavior
The program to start.

Version Number (please complete the following information):

• Version 1.2

Describe the bug
I cannot select network folders or drives. I can only see the contents of C:\Users\username

To Reproduce
Steps to reproduce the behavior:

1. Open Power BI and click External tools > Report Analyzer. Report Analyzer 1.6.3 opens.
2. Click on File > Select Folder.... On the window that opens, the only folder available is C:\Users\username

Expected behavior
I expected to be able to navigate to network mapped drives via This PC as in version 1.6.2.

Version Number (please complete the following information):

• Version 1.6.3

Is your feature request related to a problem? Please describe.
If you have a standard in the way you write reports you would like to make checks if everything is setup write and when it isn't you would like to apply a fix without opening the pbix file.

Describe the solution you'd like

1. Be able to move visuals in the report,Or align multiple visuals at once.
2. Set filters or change filters

Describe alternatives you've considered
You can also open the report and change everything by hand.

Additional context
If you want to do it in a devops way you would like to check if things are up to standard.

1. Is every visual at the right position
2. Is the right background visual being used
3. Are the right filters set
   And with a write back function you don't have to open the file it self to make adjustments.

It's frustrating to use the slicer sometimes to select Dax Query Timen especially when I want to specify by the millisecond

I want to write the exact time (Example: 1.13 seconds)

Keep the slicer but also add a box to write the number in seconds and milliseconds that I want to specify

Thank you so much for making this app, it's game-changing and it has been really helpful!!!

Is your feature request related to a problem? Please describe.
This is my first time using the application, as shown in the video of (Havens Consulting)[https://www.youtube.com/watch?v=WT_5nOPdbqk] by Michael Kovalsky. My Report has personalized dimensions that are 1900 of width for 1000 of height. With this dimensions I can't see the hole page in te report analyzer but a fraction of it, and the slicer on the rigth only allows me to go down or up, but not left or rigth.

Describe the solution you'd like
I would love to have a kind of zoom command in the panel, in order to zoom out and be able to see the hole report.

Describe alternatives you've considered
Alternatively, report analyzer could have a scroll bar to allow me to scroll from rigth to left in my report.

Additional context
I will send you a screenshot of my issue for you to see. If there is a scroll bar or a way to work this around, please forgive me for this message as I wasn't able to find it. Thanks for yout amazing application.

I am not allow to share my pbi file as it contains clients data.

Describe the bug
ReportAnalyzer crashes opening performance analyser json

To Reproduce
Initially had to map drive to pbix location so it would show in folder selector.
Open folder and see error dump 'could not find file' in Additional context section

Expected behavior
Open performance analyser file from same location as pbix

Screenshots
n/a

Version Number (please complete the following information):

• Version [i.e. 1.5.0]

Additional context

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.FileNotFoundException: Could not find file 'X:\WHOG Use Case\WHOG_PowerBI_UsageMetrics AuditDetail\Report\Layout'.
File name: 'X:\WHOG Use Case\WHOG_PowerBI_UsageMetrics AuditDetail\Report\Layout'
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.InternalMove(String sourceFileName, String destFileName, Boolean checkHost)
at System.IO.File.Move(String sourceFileName, String destFileName)
at ReportAnalyzer.newForm.<>c__DisplayClass1_0.<newForm_Load>b__10(String oF)
at ReportAnalyzer.newForm.<>c__DisplayClass1_0.<newForm_Load>b__11(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4420.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

ReportAnalyzer
Assembly Version: 1.5.0.0
Win32 Version: 1.5.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Elegant%20BI/Report%20Analyzer/ReportAnalyzer.exe

System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4400.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4360.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4390.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4390.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Newtonsoft.Json
Assembly Version: 12.0.0.0
Win32 Version: 12.0.3.23909
CodeBase: file:///C:/Program%20Files%20(x86)/Elegant%20BI/Report%20Analyzer/Newtonsoft.Json.DLL

Microsoft.CSharp
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll

System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

System.Runtime.Serialization
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4250.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll

System.Dynamic
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll

Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.8.4420.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll

Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

System.IO.Compression.FileSystem
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IO.Compression.FileSystem/v4.0_4.0.0.0__b77a5c561934e089/System.IO.Compression.FileSystem.dll

System.IO.Compression
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IO.Compression/v4.0_4.0.0.0__b77a5c561934e089/System.IO.Compression.dll

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Describe the bug
The report was not opening in report analyzer as i'm getting an error that it missing a file. I have removed every tab, letting one with two empty tables, but still getting same error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots

Version Number (please complete the following information):

• Version [i.e. 1.4.0]

Additional context
Add any other context about the problem here.

Describe the bug
When I open Report analyzer from PBI, I can't select the folder to search for the files.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'File'
2. Click on 'Select folder'

I can only select the Desktop.

Expected behavior
Should see a list of sources intead of just Desktop

Screenshots

Version Number (please complete the following information):
1.6.0

Additional context
Add any other context about the problem here.

Describe the bug
Even if I reinstall Report Analyzer the External Tool keeps using version 1.6.0 instead of 1.6.2

Is your feature request related to a problem? Please describe.
No, is a a new feature.

Describe the solution you'd like
It would be very useful if the exported metadata for the filters in the filters pane, at the visual, page and report level, included 2 more fields that indicate if the filter is locked and if it is visible (the lock and the eye options in each filter )

One of my users, for example, has a requirement that all filters at the visual object level be invisible and blocked, and having these 2 fields it would be very easy to identify which filters break this rule and go to correct them)

Thank you Michael.

Is your feature request related to a problem? Please describe.
When I pbix file has bookmarks there are more then one overlapping visuals.
So now I can't see which visuals are when.

Describe the solution you'd like
Add the bookmarks in the filter panel or something like that, so you can see which visuals is active when.

Wasn't ReportAnalyzer Open Source?

Is your feature request related to a problem? Please describe.
It's common to have unused fields in the model. Some of them could be so large that removing them would improve the refresh performance, for example.

Describe the solution you'd like
It'd be great if the tool listed the unused fields together with the portion of the database size that they occopy. Example: TableA[Column1] is not used in any visual, yet it occupies 14% of the model.

Describe alternatives you've considered
If not possible to do as an external tool due to Live Connections, I'd still be happy with a Tabular Editor script that can be executed when connected to a data model (for a list of all fields and a list of fields referenced in the model), with a local PBIX specified for layout parsing (for a list of fields used in visuals).

Describe the bug
Unable to open a folder containing a Power BI PBIX and Performance Analyzer file

To Reproduce
Steps to reproduce the behavior:

1. Go to 'File
2. Click on 'Select Folder...''
3. Navigate to the folder containing 1) a .PBIX file and 2) a performance analyzer .json file
4. See error/dialog: "Must select a folder with a Power BI Desktop or Power BI Template file."

Expected behavior
Report Analyzer opens and analyses both files.

Screenshots
See below.

Version Number (please complete the following information):

• Version 1.6.0
• Power BI Desktop Version: 2.105.1143.0 64-bit (May 2022)

Additional context
Add any other context about the problem here.

Describe the bug
It is helpful to group multiple report elements in a group on the Power BI Selection Pane. The Visual Groups are drawn in the correct location by Report Analyzer, but the elements within the group are not.

To Reproduce
Steps to reproduce the behavior:
See Power BI Desktop in attached file: Sample with Groups.zip

1. Created a chart and a text box
2. View > Selection to open selection pane
3. Select Text box and chart, right click and Group
4. Copy and paste group into second group. Optionally rename and move items.
5. Run Report Analyzer

Expected behavior
Each Text Box and Column Chart should draw on the Report Analyzer screen in the same position as the Visual Group.

Screenshots
Report

Report Analyzer

Version Number (please complete the following information):

• Report Analyzer Version 1.6.0
• Power BI Desktop September 2022

Additional context
It looks like the X and Y coordinates for items in a group are relative coordinates within the group container and not absolute coordinates for the report page:
ReportObjects_Visuals.txt

Describe the bug
I am just starting with Report Analyzer and I can't see the pages tabs at the botton as shown in this video https://www.youtube.com/watch?v=WT_5nOPdbqk in the minute 32:58. I don't know if it is a matter of my screen setting but I am not able to fix it by changing it.

To Reproduce
I wouldn't know how to reporoduce this bug, but the size of my report is 1900 * 1000.

Expected behavior
I expected to be able to navigate trough the diferent pages of the report in an easy manner as in the video stated above.

Screenshots
In this screenshot, this is the botton of the window.

Version Number (please complete the following information):

• Version 1.6.0

Additional context
I added a suggest for scrolling big size reports a few minutes ago that maybe can fix this too.

Thanks for your time.

Hi Michael, thanks for this awesome tool, when I tried to use it I got the following error below.

1. I downloaded and installed your tool.
2. I then ran the performance analyzer and exported it with the PBIX file to a folder under "My Documents\PBI Report Analyzer"
3. Next I opened up the Oct 2021 version of PBI Desktop.
4. Opened your application, browsed to the location from step 2 above.
5. I then got the error below, where I have pasted all the details.
6. I am testing this using Windows Server 2012 R2 64bit

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at ReportAnalyzer.newForm.<>c__DisplayClass0_0.<.ctor>b__2(String goTo)
at ReportAnalyzer.newForm.<>c__DisplayClass0_0.<.ctor>b__3(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4180.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

ReportAnalyzer
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Elegant%20BI/Report%20Analyzer/ReportAnalyzer.exe

System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4150.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4001.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3761.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3761.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4180.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3761.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

System.IO.Compression.FileSystem
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3761.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.IO.Compression.FileSystem/v4.0_4.0.0.0__b77a5c561934e089/System.IO.Compression.FileSystem.dll

Newtonsoft.Json
Assembly Version: 12.0.0.0
Win32 Version: 12.0.3.23909
CodeBase: file:///C:/Program%20Files%20(x86)/Elegant%20BI/Report%20Analyzer/Newtonsoft.Json.DLL

Microsoft.CSharp
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3761.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll

System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3761.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

System.Runtime.Serialization
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4180.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll

System.Dynamic
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3761.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll

Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.8.4180.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.