cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gsrk1982 Frequent Visitor
Frequent Visitor

New to PowerBI = Data model Selection

We’re pretty new to PowerBI.We explored Import,Direct query and developed some dashboards for the POC.We analysed pros and cons of both Import and Direct Query mode.So Decided to develop SSAS model.We are new to OLAP development.SSAS offering two kind of models Multi dimensional and Tabular model.Which model is advisable to start.Our business model is HCM product.For this which model suits in futuristic approach.Our OLTP Database size varies from 20 GB to 1TB.We offer both On-premise and Cloud model.

 

Kindly help me out..

 

 

 

 

 

 

 

 

 

2 REPLIES 2
saurabh_kedia_ Regular Visitor
Regular Visitor

Re: New to PowerBI = Data model Selection

Hi,

 

I think it's better to go for tabular model as Power BI continously pushing that & with every new update the limitations are reducing.

 

Moreover, please refer the link below for more info on the same.

 

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=01f3a05f-...

 

Regards,

Saurabh

gsrk1982 Frequent Visitor
Frequent Visitor

Re: New to PowerBI = Data model Selection

Thank you.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 40 members 1,005 guests