Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
We are a start-up software firm building a cloud-based application using SQL Server as the db. We're exploring possibly using Power BI as the business intelligence solution for our customer/clients.
I have a trial version of Power BI desktop installed and have connected to a local SQL Server database but can't seem to figure out how to connect to an off-premises database / data warehouse. Our current vision is to have our customer clients, using Power BI, connect to a central cloud-based database/data warehouse (with security controls/partitioned) for reports/dashboards/etc. I can't assume that the customer/clients have SQL Server.
Is there something I'm missing? Any suggestions on how to cost-effectively accomplish this with Power BI? Thanks.
Solved! Go to Solution.
@dws,
You can create reports after connecting to SQL database in Power BI Desktop, publish the reports to Power BI Service, then create dashboards in Power BI Service and share the dashboards to your customers.
Regards,
Lydia
@dws,
You can create reports after connecting to SQL database in Power BI Desktop, publish the reports to Power BI Service, then create dashboards in Power BI Service and share the dashboards to your customers.
Regards,
Lydia
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.