Forum Discussion

WanyaPING12's avatar
WanyaPING12
Frequent Visitor
1 year ago
Solved

Data Modeling and Power Query

Hello PBI Forum,  Good day! I need help on this excel data that needs to automate in the power BI. Can you help me give some tips and know how to do this in modeling and power query. I am new to pow...
Need Help
Show and Tell
Tips and Tricks
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi WanyaPING12 ,

    Please try below things.

     

    1. Data Modeling in Power BI: Create Relationships, If you have lookup tables (Owner Lookup), connect them via ID or Owner.

     

    2. Avoid Calculated Columns for Large Data.

     

    3. Use DAX Measures instead of calculated columns where possible to reduce memory usage.

     

    4. Avoid row-by-row logic in Power Query for large datasets.

     

    5. Consider aggregating data before loading into power bi if possible.

     

    6. Use Dataflows if your data source is very large and shared across reports.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi WanyaPING12 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi @WanyaPING12 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh