Quick Books Online to Power BI to Excel
How to Connect Quick Books Online (QBO) to Power BI and then to feed into Excel To connect to Quick Books using Power BI you need a specific connector: https://docs.microsoft.com/en-gb/power-query/connectors/quickbooksonline To enable authentication to Quick Books, you need to: Download the new Microsoft Edge based on Chromium You then need to go into your Environment […]
Power BI Query Performance Tests
Optimising Power Query When I first started using Power Query, I was in awe (and still am!) of all of the different transformations that you could apply to messy, messy data fairly easily to enable data reporting. I followed best practices and focused on building models using a star schema of normalised tables. I didn’t […]
Creating KPIs in Tabular Editor that work with a Selected Measure
I have been experimenting with Tabular Editor and Power BI Desktop for a few months now and looking at and using Tabular Editor to create KPIs. The tutorials that I used are Creating KPIs in Power Bi Desktop, Tabular Models for Power Bi & Excel both from SQLBi.com, and Calculation Groups with Tabular Editor from […]