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!!

I have the same question (0)

All responses (4)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply, how do I see that?

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Copy link

Link copied!

You can check these properties

There are corresponding tables in the AxDW database

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

thanks

Was this reply helpful? Yes No