In the image 1 have 3 repeating columns known as ID and then 3 columns as description. How can I make 1 column ID and 1 Column Description.

I need to extract a table with selecting columns in power query dynamically.

This contains the Opportunities entity which references the columns you are referring to. Since these values are not likely to change for Dynamics Option Set data types I typically create simple Power …

You can use CAML to perform your query if you want to sort by more than 2 columns.

I'm having an issue referencing another query that starts with: Source = Access.Database (Web.Contents (<URL to .accdb file hosted on Sharepoint>))

Power Query does not support SQL Server 2000. I believe it will work with SQL Server 2005, but if I remember correctly the earliest "officially supported" version is 2008. There were a lot of changes to …

I need to dynamically populate a group based on a SQL query to a seperate database. Here's the scenario. I need to set different notification windows on certain servers. I can glean the status of …

"Stop if the computer switches to battery power" selected. This means anyone in my work environment that wants to log onto the network wired/wireless using a laptop running on battery power, will not get …

I have tried to query the system log by using CMPivot, the syntax is correct but it seems to query log only return the latest 50 records that seem useless. I'm not sure if it is by design or I am doing …

How can I instead make the trigger envoke/call a powershell script that can perform the same query and send an e-mail? Apparently we do have e-mail functionality for our scripts, so that part I can just …