power BI Setup in VM

(0) Share

Report

Posted on by vannamani77

417

Hi,

How to Install Power BI setup in D365 Virtual Machine box.

Regards,

Manivannan

I have the same question (0)

All responses (20)

Answers (0)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

You can install power BI desktop in your one box.

Take a loo at below thread as well if you want to enable power bi embedded experience in one box.

www.axug.com/.../viewthread
vannamani77 417 on at

Like (0)

Report

what is one box? Is this any third party app.
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

I mean to say your VM
nmaenpaa 101,162 Moderator on at

Like (1)

Report

It's installed in exactly the same way than it's installed to any workstation. Download the installer and run it. Assuming you talk about Power BI Desktop. The cloud version of Power BI can't be installed anywhere, it runs in the cloud.
Rahul Mohta 21,032 on at

Like (0)

Report

ADDITIONALLY could check this

blogs.msdn.microsoft.com/.../
vannamani77 417 on at

Like (0)

Report

When I install BI desktop it ask me to enter password for admin***

But I there is only one login given in LCS. That is builtin\Userc2*****

Pls help how to install the BI desktop
nmaenpaa 101,162 Moderator on at

Like (0)

Report

You can't install new software in the Microsoft managed dev box. You can only install new software in dev boxes that you host in your Azure subscription (Cloud hosted environments) or run locally (Downloadable VHD).
vannamani77 417 on at

Like (0)

Report

In this scenario how to develop power bi reports and integrate with d365.
nmaenpaa 101,162 Moderator on at

Like (1)

Report

There are many options.

What kind of report are you thinking about?

You need to know that you can't access D365 prod database with Power BI, so your report can't be based on SQL queries. Unless you use BYODB, export entities from your D365 to your own Azure SQL database, and report from that database.

If you want to connect directly to D365, you need to connect via OData. The OData endpoints are accessible from anywhere, so you don't need to install Power BI in your dev machine, instead install it on your own workstation. Or use the cloud version of Power BI. Then connect to yourD365EnvironmentURL/.../Customers to get customer data, and this same way you can access any public data entity.

OData is quite slow so you can't use it for heavy transactional reporting. In such scenarios you can use BYODB. Or export to Data Lake, which I believe is still in preview.

For more info, you can do web searches about the topics and technologies mentioned above.
vannamani77 417 on at

Like (0)

Report

Hi,

Is it possible to Connect to SQL Database of Online Dynamics 365 FO through Power BI Desktop from my local PC ? Any configuration need to be done from SQL side in One box ?

Regards,

Manivannan