The Challenge of Multi-Tenant Data Solutions As a data and analytics consultant serving multiple customers, one of the biggest challenges […]
Using Microsoft Fabric to serve multi-tenant data & analytics Read More »
I created a Fabric Dataflow Gen2 Web API connection to retrieve csv file data from an Environment Canada daily environmental
Fabric Dataflow Gen2 Web API connection with dynamic current date parameter Read More »
What is Power Query? Power Query is an Microsoft tool for Excel and Power BI that is used to do
Introduction to Microsoft Power Query in Excel and Power BI Read More »
I have a local Hadoop server running on my Windows laptop. To connect Power BI to this Hadoop file system
How to use Hadoop HDFS as a datasource for Power BI Read More »
Step 1 – Download latest version of Power BI to get new features (version that came out in early August
How to use Python as a datasource for Power BI Read More »
I recently changed my Office 365 user password for an account that I was using for a Power BI Dataset
How to update Office 365 password in Power BI dataset refresh Read More »
A Power BI Report with multiple charts or other objects can be added to a Dashboard in Power BI Online
How to avoid wide margins on a Power BI dashboard Read More »
This was a weird quirk. I have Power BI Free account and uploaded a report to Power BI Service. The
Careful! Don’t click “Try Power BI for free” Read More »
Do you want to create a Power BI Report that gets a daily scheduled refresh of data from a Sharepoint
How to schedule Power BI dataset refresh Read More »
I want to create a Power BI Online report with a data source from a file on a remote web server that updates
Power BI Online – get data from Office 365 Sharepoint file Read More »
Microsoft has three file storage options: OneDrive Personal OneDrive Business Sharepoint These have recently been unified into one new OneDrive API https://dev.onedrive.com and oAuth
OneDrive API features Read More »
BC Hydro made an amazing social media turnaround to communicate with customers in crisis! Go BC Hydro! On August 29,
BC Hydro’s amazing #BCStorm social media turnaround Read More »
Microsoft has a free Microsoft Data Management Gateway that you can install on your desktop or server to act as
How to create OData data source Gateway for Power BI Report Read More »