Forum Discussion

WanyaPING12's avatar
WanyaPING12
Frequent Visitor
11 months 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
    11 months 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

MFelix's avatar
MFelix
Super User
11 months ago

Hi WanyaPING12 ,

 

First of all I believe that you need to split this into 2 different parts the data treament STEP 1 that will allow you to have the data in a format you can use and the rest of the steps that can be done using DAX calculations.

 

Can you please share a mockup data or sample of your XLSX file (the one you identify on  step 1). You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

WanyaPING12's avatar
WanyaPING12
Frequent Visitor
11 months ago

Thank you MFelix. I've shared the mockup data thru private message.