This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 87%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Good day all,
I would like to inquire whether it’s possible to connect SQL Server to SharePoint, given the size of our organization, many associates prefer to access and share data through our existing SharePoint channels.
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
Good day, Akhil, the idea is incredible, I am still working around some inhouse securities will execute the idea as soon as I sort the internal issues.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Hi @Mani, Sibusiso {PEP},
Connect Power BI to SQL Server (via gateway if on-premises).
Create reports and dashboards in Power BI
Embed Power BI reports in SharePoint Online using the Power BI web part.
Users can view live data without accessing SQL Server directly.
Thanks,
Akhil
Hi @Mani, Sibusiso {PEP},
Just checking in were you able to connect Power BI to your SQL Server and embed the reports in SharePoint Online as suggested?
If you ran into any issues with the gateway, report visuals, or live data refresh, feel free to share the details so we can help troubleshoot.
Thanks,
Akhil.
Hi @Mani, Sibusiso {PEP},
Good day. Just wanted to check in were you able to sort out the internal security concerns and give the idea a try? Would love to hear how it’s progressing once you’ve had a chance to implement it.
Thanks,
Akhil.