Forum Discussion
Excel to PowerBi: Process organization
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
3 Replies
Hi GiulianoPowerBI
Please refer to the linked discussionhttps://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
Thank you. Seems like have to keep the logic separate and load final results to PowerBi just for visualization.
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
