cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MangoJuice
Frequent Visitor

Is it possible to have POWER BI version similar to MS Dynamics CRM on-Premise?

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.

1 ACCEPTED SOLUTION
waltheed
Solution Supplier
Solution Supplier

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,

 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant

View solution in original post

3 REPLIES 3
waltheed
Solution Supplier
Solution Supplier

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,

 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant

Thanks for your quick response!

You're welcome. Glad I could help.

 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors