Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi There,
I am new to POWER BI. Since wokring in Healthcare field. As you might know eveything has to be local, nothing should be connected to outside world.
I would like to create a small demo dashboard with SQL Server Database of MS Dyanamics CRM connection with POWER BI, but same time I don't want that data to be sync on cloud or somewhere online , since is healthcare data. I would like to just have standalone application.
Which Power BI product, I should use?
Thanks.
MangoJuice.
Solved! Go to Solution.
Hi MangoJuice,
Power BI Desktop is a perfect first choice for this scenario.
Certainly for the first phase, to figuire out what data to use and how to transform and display it.
In a later stage you can move the data model to an (on prem) tabular model on the sql server. You can keep the reports in a Power BI desktop file.
It will soon be possible to publish Power BI reports to an on-prem sql server. (this feature is currently in preview (requires sql 2016)). Then sharing with other (internal) colleagues is also possible.
Then you have a great on-prem Power BI solution.
HTH,
Hi MangoJuice,
Power BI Desktop is a perfect first choice for this scenario.
Certainly for the first phase, to figuire out what data to use and how to transform and display it.
In a later stage you can move the data model to an (on prem) tabular model on the sql server. You can keep the reports in a Power BI desktop file.
It will soon be possible to publish Power BI reports to an on-prem sql server. (this feature is currently in preview (requires sql 2016)). Then sharing with other (internal) colleagues is also possible.
Then you have a great on-prem Power BI solution.
HTH,
Thanks for your quick response!
You're welcome. Glad I could help.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
66 | |
43 | |
42 |
User | Count |
---|---|
46 | |
38 | |
28 | |
27 | |
26 |