Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.