Share via

How deploy copilot using Vscode when running PowerBI backend?

Garrett Settles 0 Reputation points
2026-02-25T22:25:54.2266667+00:00

I'm hosting a 2022 SQL Server Adminstrator on an Office instance of m365, but the boot screen doesn't allow for adminstrator privelege access for the powerbi backend. How to fix?

SQL Server | Other
0 comments

Answer recommended by moderator

  1. Akhil Gajavelly 1,820 Reputation points Microsoft External Staff Moderator
    2026-02-26T06:30:12.77+00:00

    Hi @Garrett Settles ,

    When hosting SQL Server 2022 on M365 Office instance, the boot screen doesn’t allow administrator access for Power BI backend.

    1. Run SSMS as Administrator: Right-click SQL Server Management Studio and choose Run as Administrator to get full access.
    2. Check Permissions: Ensure your SQL login has sysadmin rights. In SSMS, go to Security > Logins and verify that the correct account has sysadmin role enabled.
    3. Power BI Access: Make sure the Power BI service has the right permissions to connect to your SQL Server. Use either Windows or SQL Authentication depending on your setup.
    4. Network/Firewall: Double-check that no firewall rules are blocking the connection between Power BI and SQL Server.

    If this doesn’t fix it, take a look at the error logs in both Power BI and SQL Server for more clues.

    Hope that helps. Let me know if you need further details.

    Thanks,

    Akhil.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. kagiyama yutaka 1,830 Reputation points
    2026-03-08T09:44:16.75+00:00

    I think ur issue comes from the M365‑join dropping elevation before SQL wakes, so a single login with real local‑admin to bring the SQL svc up is the cleanest fix… and giving PowerBI read/exec on the share early avoids the next stall.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.