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

Accepted Solutions
waltheed Solution Supplier
Solution Supplier

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

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
Power BI User Group Netherlands

View solution in original post

3 REPLIES 3
waltheed Solution Supplier
Solution Supplier

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

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
Power BI User Group Netherlands

View solution in original post

MangoJuice
Frequent Visitor

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

Thanks for your quick response!

waltheed Solution Supplier
Solution Supplier

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

You're welcome. Glad I could help.

 

Cheers, Edgar Walther
Power BI User Group Netherlands

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors