topic Re: Star schema in Developer

Star schema

Bakhtawar — Fri, 08 Nov 2019 06:31:26 GMT

Hi all ..

In my power bi application i have a lot of tables.. now i want to create star scheama .. i have idea how to create start scehma but currently the data model tables i have is so complicated and i have no idea how to create

any help

Re: Star schema

Jayendran — Fri, 08 Nov 2019 08:39:49 GMT

Hi @Bakhtawar

For such a complex data model, refer the official guidance doc by powerbi

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Re: Star schema

Bakhtawar — Fri, 08 Nov 2019 10:00:22 GMT

i dont understand this ..

i mean i alerady have tables so how i create fact table from exisiting tables.. will i create table another manually and add respective columns one by one in face table ? is this possible to first create view of face table and from that view we able to create table ?

i mean will i add columns manually in face table