How do I export views

(0) Share

Report

Posted on by AstridMalanka

the system has premade power bi reports. I would like to deploy to power bi reports into power bi.

As I understand it cannot be done, and I will need to recreate the power bi report.

Is there any way I can export the premade views into my own database? I am looking into it, and it is very confusing.

The report bring data from "Invoice", I cannot find a table nor a view called invoice.

So I took a view [dbo].[ProductionCube_Company] and it takes data from ProductionCube_BICompanyView_MATERIALIZED that is a table on AxDW (I am trying to understand what is going on), but I cannot find the procedure that loads that table.

Does anyone know how it works?

Thanks a bunch!!

All responses (4)

Answers (1)

AstridMalanka 8 on at

Like (0)

Report

RE: How do I export views

thanks
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report

RE: How do I export views

You can check these properties

There are corresponding tables in the AxDW database
AstridMalanka 8 on at

Like (0)

Report

RE: How do I export views

Thanks for the reply, how do I see that?
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: How do I export views

Hi Astrid,

AXDW database is populated from the D365FO entity store which has all the cubes. These cubes have underlying views designed that you can take a look at.