Step Folding Indicators for Power Query Online
Query Folding
Feb 1, 20213 min read1
Command Palette
Search for a command to run...
#powerquery
Articles tagged with #powerquery
Data Professionals spend an average of 23% of their time cleaning data — here’s a BulkTextReplaceValue function to save you some time 🕒
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 professionals found that data scientist spend about 40% of gathering and cleaning data, 20% of their time bui...
Sep 7, 20203 min read2
Setting a scheduled refresh on a Dynamic Data Source in Power BI
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 query, because the data is generated in code or returned from another data source. Examples include: th...
Sep 4, 20202 min read8
My dataset is taking too long to refresh!
Performance tuning dataset refresh in Power BI
Jul 12, 202012 min read7Get members of a security group in Power BI using Power Query
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 a list of users from a specific security group? Simply use the Power Query script below and cha...
Jun 22, 20201 min read32