Getting Data from IBM TM1 (Cognos) by Get and Transform …
Sep 26, 2019 · I am working with IBM TM1 reports and Views. I am also working on a Data Model in excel, getting Data from different sources (SQL, Internal Portal, Excel Tables, Etc). A critical …
[Expression Error] The import AnalysisServices.Database matches …
Aug 22, 2018 · So the issue turns out to be that the users are running on an older version of Power Query that does not include the AnalysisServices.Database function. Upgrading all …
MS Excel Power Query not refresh if file is not open when …
Anyone knows why the closed file cannot get refreshed as configured or this is the requirement by MS Excel to keep the file open for refreshing data in regular basis (every x minutes)? Any …
Postgresql failed to establish connection
May I know the version of Excel and PostgreSQL that you are using? As far as I know, we usually use Power Query to connect PostgreSQL database, did you use this method?
running simple query against MS Access database very slow
I set up some queries in Excel using power query, really very new to it, and trying to see how it can add benefit to my processes, as well as to potentially provide some end user reporting.
Round decimal number to whole number in power query
Question 0 Sign in to vote Dear All, I want to write the query to get the whole unit column as per below table is calculated whole unit column in Excel
Has the Buffer's End been reached? - social.technet.microsoft.com
I try to link excel 2016 and power query to a web service hosted by a shared server. When trying to establish connection with the service, the following message is presented: "Can not connect:
Removing trailing characters - social.technet.microsoft.com
The MSDN website has a great resource for finding solutions. Just go to the "text functions" because you are having a "text" problem, and then in your text you said you wanted to …
Power Query to Generating all combinations from single column
Here, below is the result of my thoughts function fxPossibleCombinations (t as table) as table => //Do not use for more then 19 stores if you want to get ResultTable in excel sheet due to rows …
Detect Data Type for fields/columns dynamically and convert …
Power Query has a fairly decent automatic data type detection option if you select all of your columns in the UI and use the Detect Data Type button (at least in Excel 2013, I can't find the …