cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Data Model for Sales Data

 

 

Seeking some help to build financials in Power BI...Needing to report monthly financials for sale's by regions. Looking to transitions into new model for 2018. Couple of questions...

 

Should data model be put into query or table? If so, why would you recommend one over the other?

 

Any other foundational tips or tricks for building out the data model would be much appreciated.

 

Thanks.  

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Data Model for Sales Data

@Anonymous,

 

What is the query or table do you refer to? Do you mean DirectQuey mode and import mode? If so, I would recommend you go through the difference between DirectQuery and Import which is described in the following video, then make a decision for your model.

https://channel9.msdn.com/Blogs/MVP-Data-Platform/Diferences-between-Direct-Query-and-Import-in-Power-BI

 

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Data Model for Sales Data

@Anonymous,

 

What is the query or table do you refer to? Do you mean DirectQuey mode and import mode? If so, I would recommend you go through the difference between DirectQuery and Import which is described in the following video, then make a decision for your model.

https://channel9.msdn.com/Blogs/MVP-Data-Platform/Diferences-between-Direct-Query-and-Import-in-Power-BI

 

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Data Model for Sales Data

Eh that's a bummer, I don't think I will be able to use direct. 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors