Excel to PowerBi: Process organization

[GiulianoPowerBI]

Hello,

I've an implementation that end up with a report in PowerBi.

Process starts from a series of table and .csv update with monthly frequency.

I started organizing folder and setting up PowerQuery in order to refresh pull up data into excel as needed.

So I built the data model in Excel.

My point is that from here I perform several calculation that are code in VBA and that cannot implement through formulas (DAX ecc). So I trasnfered the final result (as a big denormalized table) to PowerBi to show the report.

Do you have any suggestion to improve the flow? I couldn't start from PowerBi directly collecting data as I counl'd apply the VBA logic.

Thank you for any help

Giuliano

[Ritaf1983]

Hi @GiulianoPowerBI 
Please refer to the linked discussion

https://community.fabric.microsoft.com/t5/Desktop/From-Excel-with-VBA-to-PowerBI/m-p/207351

It is pretty old, but nothing has changed since these days related to VBA.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[GiulianoPowerBI]

Thank you. Seems like have to keep the logic separate and load final results to PowerBi just for visualization.

[Ritaf1983]

@GiulianoPowerBI 

Yep, many developers do the same with SQL / python / data bricks etc... 🙂

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly