Kategorie: Allgemein

Ursprünglich veröffentlicht auf business intelligist: I have to admit, I like Power Query more and more every day. Even though on one hand sometimes I feel that the tool will only appeal to a very specific type of power users, on the other hand, I can’t help but feel that the tool is so good…

Ursprünglich veröffentlicht auf Dick Moffat's Spreadsheet and BI Blog: I got into a bit of a disagreement with someone today over the idea of Pre-Aggregation of data before bringing it into PowerPivot in Excel as opposed to bringing in all the source data for all the tables to be analyzed and then doing all the…

Chris Webb's BI Blog An interesting Power Query nugget for you: you can compare two tables using the Value.Equals() function. For example, take the following worksheet with five Excel tables on it: The following Power Query query compares Table 1 with each of the other four tables and tells me whether they are identical or…

Ursprünglich veröffentlicht auf Dick Moffat's Spreadsheet and BI Blog: I have just completed a major conversion of one of my „traditional“ spreadsheet reporting solutions to PowerPivot for a major coal mining company.  It has been one of the most satisfying solutions I have ever done and convinces me even more than before of the importance…

Ursprünglich veröffentlicht auf Devin Knight: One of the nice new features that was added to Power Query with the latest update in December is the ability to connect to Microsoft Exchange as a data source.  You can download this update now here: http://www.microsoft.com/en-ca/download/details.aspx?id=39933 Here’s a quick demonstration of how you may use the Microsoft Exchange…

Ursprünglich veröffentlicht auf Devin Knight: Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates.  The list of updates can be found here but for my notes specifically on Power Query updates continue reading! Power Query Power Query now has 3 new data sources that you…

Chris Webb beschreibt in diesem Beitrag, dass es mit Power Query theoretisch möglich ist, Daten im SQL-Server Backend zu aktualisieren. Ist sicher nicht gerade das, was sich die meisten DBA’s wünschen… Chris Webb's BI Blog As of the November update of Power Query, it’s now possible to write your own SQL query when you’re moving…