Ian's blog
Tag

PowerQuery

#powerquery

More content

Read more stories on Hashnode

Articles with this tag

Data Professionals spend an average of 23% of their time cleaning data — here’s a BulkTextReplaceValue function to save you some time 🕒

Sep 7, 20203 min read

Proportion time spent on data science activities In Bob Haye’s article from earlier this year, results of a recent study of over 23,000 data...

Data Professionals spend an average of 23% of their time cleaning data — here’s a BulkTextReplaceValue function to save you some time 🕒

Setting a scheduled refresh on a Dynamic Data Source in Power BI

Sep 4, 20202 min read

A dynamic data source is a data source in which some or all of the information required to connect cannot be determined until Power Query runs its...

Setting a scheduled refresh on a Dynamic Data Source in Power BI

My dataset is taking too long to refresh!

Jul 12, 202012 min read

Performance tuning dataset refresh in Power BI · ⏳ one eternity later… The almighty Chris Webb recently did a presentation on performance tuning dataset...

Get members of a security group in Power BI using Power Query

Jun 22, 20201 min read

You may already know that there is an existing connector to your on-premise Active Directory Get Data > Active Directory But what if you only need to...

Get members of a security group in Power BI using Power Query