Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello folks,
last year I established a working PowerBI report for financial data, like Profit&Loss. The data comes from an SAP BW downloaded into excel and shows the the P&L or Balance Sheet items for the reporting entity by month. Actual, Budget and Forecast are three separate Excel files/sheets.
Last year I consolidated Actual, FC and Budget in one big fact table.
I wonder if from performance as well as development point (meaning easier to make measures) of view it would be better to not have consolidated Actual/Budget/Forecast into one table, but keep them separate.
Best regards,
d
Hello @amitchandak,
I download the following from BW into Excel for one Fiscal year:
1 Excel file with 2 sheets for Actual and FC unconsolidated
1 Excel file with Budget unconsolidated
1 Excel file with 2 sheets for Actual and FC consolidation
1 Excel file with Budget consolidation
Each file about 2-3M of data. Each table 32 to 35 columns. (Actually could reduce it by 12 as I so far calculate only with the actual period data, but the report exports actual month and Year to Date.
I plan to have 3 - 4 years in the power bi.
Current PIBX size is below 3MB with 2 years.
@danielboi , How much is the size. It depends on the overall size and the number of columns.