Power BI- Data Connectivity Modes

Import Data This connection means that Power BI will cache the data meaning Pulling data from Data Source and into Power BI Desktop File. Advantages: Caching the data makes you take full advantage of Vertipaq Engine. Report Performance will be better using Import.Able to Use full capabilities of Power BI using relationship types, M and … Continue reading Power BI- Data Connectivity Modes

Sample Financial Reports for Adventureworks (Updated)

** Update 29/05/2021 - Newer samples are now available on GitHub at https://github.com/ProdataSQL/FinancialModelling The PBIX is preloaded, so you don;t need to load files, but if you don want to, you will need to change file locations to match where you ahve downloaded files too ** I updated my AdventureWorks Sample Report to include CashFlow, … Continue reading Sample Financial Reports for Adventureworks (Updated)