pnp / pnpassessment

Microsoft 365 SharePoint Assessment tool enabling various deprecation and adoption scenarios
https://aka.ms/microsoft365assessmenttool
MIT License
28 stars 14 forks source link

Reports are coming out blank after running "SharePoint Add-In and Azure ACS Assessment" tool #38

Closed spcodehelp closed 8 months ago

spcodehelp commented 9 months ago

We tried to run "SharePoint Add-In and Azure ACS Assessment" tool against one site collection where we know we have created ClientIDs/Secret. The reports are coming blank. Appreciate taking time to look into it.

jansenbe commented 9 months ago

@spcodehelp : can you cross check you've granted the correct permissions for the app used in the assessment run. See https://pnp.github.io/pnpassessment/addinsacs/requirements.html#permission-requirements. If you've excluded the Application.Read.All scope then no ACS principals will be reported but the run itself will not fail.

spcodehelp commented 9 months ago

Hello @jansenbe - Thank you for your quick response. I have reverified and confirmed that the application has required access as mentioned in the article. Attach is a screenshot for reference:

AppPerms
jansenbe commented 9 months ago

@spcodehelp : did the run have any errors (see last tab of the Power BI report). Can you try adding a new (not expired) ACS principal to that site (via appregnew.aspx and appinv.aspx) and check if that shows up?

spcodehelp commented 9 months ago

@jansenbe - No, the run didnt have any errors. The tool is completing in 15 seconds. When I tried to generate csv report, all are coming blank. But when I tried to generate powerbi report, it threw an error saying that "Error creating report for the assessment tool at the path is denied. Also opening a generated report in PowerBI is failed. We ran the tool using the AppId/Certificate.

jansenbe commented 9 months ago

@spcodehelp : that's all weird. Can you share the log files with me (bjansen@microsoft.com)

jansenbe commented 8 months ago

Closing this one, issue was related to not using the correct setup with vanity urls