Do you have a better suggestion on how to simulate the excel formulas shown? In the example, cell I11 refers to cell I10, etc. and power query doesn't like that.

I try share this queries to Power BI. But I cannot use this query at the other excel workbook.

Is there a way to create Power Query queries that connect to Linkedin API permanently (like Power Query does with Facebook)? I know it is possible to access Linkedin API the way Shish Shridar did …

I'm trying to convert a python script to be a Function for Power BI (Power Query M) the code below takes a list of coordinates (Lat, Long) and returns a central point for the list.

In Excel 2010, there is no effective way to identify the Office SKU for an add-in like Power Query. Chances are that you were using a non-ProPlus version without Software Assurance, which is not …

I'm running Power Query on an Azure VM to evaluate its features: its an 'Extra Large' box so has plenty of oomph. But Power Query seems to be unsuably slow: I'm trying to follow the 'getting started guide' …

Apr 15, 2019 · how to collect in excel the list of servers have a DHCP configuration scope and for each of those server display the range of scope Ip adress range using power query ?

Sep 26, 2019 · A critical data source is a complex View I have on TM1. I can export the view as *.cma (CSV) but I would rather connect to it as a Data Source (like ODBC or DB) since then I know the …

Or as mentioned in my first reply, use "query session" to see the details, for example, use query seesion to list all seesion names and query session <id> to find what other session ids represent for Yolanda …

Aug 3, 2011 · As you can see in this screenshot of my Windows 7 power policy, the GPO clearly states that the power button should turn the computer off. However, when I hit the power button it actually …