search

m-kovalsky / ReportAnalyzer

A tool for visualizing and analyzing a Power BI report's performance.
MIT License
92 stars 15 forks source link

Error Message: Could not find file #7

Open brianneilcarneiro opened 2 years ago

brianneilcarneiro commented 2 years ago

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

image image

Version Number (please complete the following information):

Additional context Add any other context about the problem here.

Chris-Burgess-ACTGOV commented 2 years ago

Getting same with version 1.5.0. See issue (https://github.com/m-kovalsky/ReportAnalyzer/issues/8)

m-kovalsky commented 2 years ago

This is pretty strange as every Power BI desktop or template file has a Report\Layout file. Would you try the following:

  1. Backup your PBI Desktop file
  2. Change the extension of your PBI Desktop file to .zip
  3. Open the .zip file
  4. Within the 'Report', see if there is a 'Layout' file.

Also, would be curious for you to attach a copy of your .pbix file if possible.

Chris-Burgess-ACTGOV commented 2 years ago

Hey Michael can confirm that the model is not corrupt and has all the folders/endpoints viewing as zip. Its way too big to zip/send unfortunately. (800mb)

Funny that after the initial errors it seems to be working per spec - for the offending file and other performance analysed exports as well.

I think the issue arose from lack of space on the file share i am using (has been problematic) to store the pbix in development.

Note: I had to make a drive mapping to this location so the reportanalyzer could find location - no unc pathing - but that's not an issue) - maybe a feature request if people use sharepoint etc for pbix storage/wip??

I will keep smashing the analyser - certainly a great tool for providing visualisation troubleshooting; and the recommendations are the bomb!!

Cheers

Chris

Chris Burgess | 620 55438 | 0403472887

@.***

From: m-kovalsky @.> Sent: Sunday, 9 January 2022 9:01 PM To: m-kovalsky/ReportAnalyzer @.> Cc: Burgess, Chris @.>; Comment @.> Subject: Re: [m-kovalsky/ReportAnalyzer] Error Message: Could not find file (Issue #7)

CAUTION: This email originated from outside of the ACT Government. Do not click links or open attachments unless you recognise the sender and know the content is safe.

This is pretty strange as every Power BI desktop or template file has a Report\Layout file. Would you try the following:

  1. Backup your PBI Desktop file
  2. Change the extension of your PBI Desktop file to .zip
  3. Open the .zip file
  4. Within the 'Report', see if there is a 'Layout' file.

Also, would be curious for you to attach a copy of your .pbix file if possible.

- Reply to this email directly, view it on GitHubhttps://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fm-kovalsky%2FReportAnalyzer%2Fissues%2F7%23issuecomment-1008266511&data=04%7C01%7C%7Cbad8cc080db34402278708d9d356fc2e%7Cb46c190803344236b978585ee88e4199%7C0%7C0%7C637773192824071361%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=YM4pLbcEOo9PsKOdhCY%2BSXKsOTck9rygwVUXGQIG9oM%3D&reserved=0, or unsubscribehttps://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAOMTRT4YE3MPASWUFNWIDVDUVFMG3ANCNFSM5LHRZUPQ&data=04%7C01%7C%7Cbad8cc080db34402278708d9d356fc2e%7Cb46c190803344236b978585ee88e4199%7C0%7C0%7C637773192824071361%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=vJZaavR9vy%2F9U%2FggygMJrrzzbay6WPJWuVrnOojAVX0%3D&reserved=0. You are receiving this because you commented.Message ID: @.**@.>>

This email, and any attachments, may be confidential and also privileged. If you are not the intended recipient, please notify the sender and delete all copies of this transmission along with any attachments immediately. You should not copy or use it for any purpose, nor disclose its contents to any other person.

brianneilcarneiro commented 2 years ago

Hi Michael,

I zipped the file, but i could not open it afterwards. I think the problem could be because the PBI is connected to a SQL Server Analysis Services Database. I tried to replicate these steps, with another data source and was able to zip and open the file.

image

Here is the zip file, but i dont think you will be able to open it: Report.zip

m-kovalsky commented 2 years ago

@Chris-Burgess-ACTGOV I will be releasing a new version (1.6.0) shortly which will have the option to input the folder path directly (without searching for it). Hopefully that resolves the issue for you. @brianneilcarneiro the issue is not related to PBI Desktop connecting to SSAS (I have tested this several times and it works fine). I'm unable to open the zip file you sent.

m-kovalsky commented 1 year ago

Hi folks, I believe the solution to this issue is to set the Sensitivity Label for the Power BI Desktop file. Please try this and let me know.