Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

OLTP Architecture Design

hi team   we are in process of developing power bi reports for our business and i need few architectural questions for below :   we have OLTP system with normalized data and the data size is 4GB ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.


    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

You’d better not to go with modeling at power BI.

 

Setting them up in Power BI takes more time. I don't find it quite as easy as doing it in SQL. For example, Power BI doesn't allow you to join two tables together on more than one column. So if you need to join two tables together on more than one column, you need to create another column in Power BI to concatinate the other columns, and then join on that. joins in DAX are costly on performance, so your reports may be slow, which could be a disaster.

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi v-frfei-msft

 

so you want me do everything at SQL and pull the data right?

 

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous,

     

    In your situation, Yes!

     

    Regards,

    Frank

    • v-frfei-msft's avatar
      v-frfei-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous,

       

      Does that make sense? If so, kindly mark my answer as a solution to close the case.


      Regards,
      Frank