The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello
I am new to power BI. I am becoming fairly competent at single source, or even 2 or 3 source reports when they are operational, snap show in time type reports. Fairly straight forward.
I have a need to develop a some financial reports against JD Edwards Financial GL data. Reports will need to be over time, historical, rolling date perspectives (month over month, qtr over qtr etc).. May have some complex inner join and query logic.
Is this type of reporting, which would it seems to me, needs a more Kimball style star schema model, with dimensions, measures and fact tables, POSSIBLE in Power BI? If possible, what are the drawbacks, performance issues, stumbling blocks? What are best practices for developing this way?
Or is it the case that it is not really possible?
Do I need / require a data warehouse / cube?
Thanks in advance!
@Anonymous , refer this is possible
https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223
Star Schema is recommended
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
Best Practices
https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-The-Do-s-and-Don-ts-of-Power-BI-Relationships/td-p/712566
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-should-I-do/td-p/712567
User | Count |
---|---|
69 | |
65 | |
63 | |
55 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
42 |