Power Query announcements
-
Link
Olá
O Power BI Preview está disponível em seis idiomas, mas a documentação e o suporte para o fórum estão atualmente disponíveis apenas em inglês. Você pode usar o www.microsofttranslator.com para traduzir o conteúdo do fórum.
Salut
Power BI Preview est disponible en 6 langues, mais la documentation et le forum d'assistance sont actuellement seulement disponibles en anglais. Vous pouvez utiliser www.microsofttranslator.com pour traduire le contenu du forum.
Hallo
Die Power BI Preview ist in sechs Sprachen verfügbar, aber Dokumentation und Forumunterstützung sind momentan nur auf Englisch verfügbar. Sie koennen www.microsofttranslator.com verwenden, um den Inhalt des Forums zu übersetzen.
Hola
Power BI Preview está disponible en seis idiomas diferentes, pero la documentación y foros de soporte sólo están disponibles en Inglés. Puedes utilizar www.microsofttranslator.com para traducir estos contenidos.
Hello
Power BI Preview is available in six different languages, but the documentation and support forums is only available in English. You can use www.microsofttranslator.com to translate this content.
こんにちは
Power BI Previewは六カ国語にてご提供させていただいていますが、ヘルプとフォーラムなどのサポートは現在英語のみです。あらかじめご了承ください。ヘルプがご必要な場合はwww.microsofttranslator.comの機械翻訳をお試しください。
Power Pivot announcements
-
Link
The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.
We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:
- http://powerpivot.com/download.aspx
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca
Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.
-
Link
If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.
The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.
Kathy MacDonald
SQL Server Analysis Services -
Link
Summary
=============================
If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.
More Information
=============================
The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.
The solution is to upgrade the beta components to their released versions when they become available.
-
0 VotesTotally remove a single word in parentheses for each row in the query
I'm following a tutorial where I end up "Copying" a string in parentheses in a new column using Add Column then Extract. Ex: "Dress Model A (Blue)" or ...Unanswered | 2 Replies | 182 Views | Created by Daniel Lamarche - Thursday, June 25, 2020 6:05 AM | Last reply by Imke Feldmann - Saturday, June 27, 2020 2:37 PM
-
0 Votes
Bottom row has error
In my power query I have a row of 'Error's across the entire bottom row. This is causing the rest of the files in my folder to not be accessed and I suspect that this is the reason that I ...Unanswered | 1 Replies | 125 Views | Created by technet_kev - Thursday, June 25, 2020 2:31 PM | Last reply by Imke Feldmann - Saturday, June 27, 2020 2:35 PM -
4 Votes
Section=ResponseHeader Detail=CR must be followed by LF
I want to query the following API and parse the json response in the selected cells through PowerQuery for Excel 2010 (last ...Answered | 14 Replies | 29712 Views | Created by Fullhdpixel - Saturday, May 31, 2014 9:03 PM | Last reply by Vannago - Friday, June 26, 2020 5:11 PM -
1 Votes
Replace everything between brackets (plus brackets)
Hello guys, Is there something similar to replace (*) in Power Query? I need to accomplish the ...Answered | 11 Replies | 437 Views | Created by Jqarroyo - Monday, May 4, 2020 9:37 AM | Last reply by Bill Szysz - Thursday, June 25, 2020 1:21 PM -
0 Votes
Web Query keeps "refreshing" even when vba code prevented
I have a really strange problem with my excel web API power query connection. It is suppose to download a file from API and it works really fine. However it should ONLY do so when i click a button ... -
0 Votes
Column transformation
Hello, I need help to transform a column who contains a long string to (different length) into a multiple columns. (split the ...Unanswered | 1 Replies | 166 Views | Created by GEORGEOT Cédric - Wednesday, June 24, 2020 11:47 AM | Last reply by Herbert Seidenberg - Wednesday, June 24, 2020 4:50 PM -
1 Votes
How to dynamically pass cell values as a parameter for new PowerQuery?
Hello I created a connection to REST API using PowerQuery in Excel2016 and it gets me information about companies. In a certain query table, ...Unanswered | 1 Replies | 261 Views | Created by Nietoperz99 - Monday, June 15, 2020 3:37 PM | Last reply by Ehren - MSFT - Monday, June 22, 2020 5:44 PM -
3 Votes
Customizing a PowerPivot slices - PowerPivot v2
Hi, in a my workbook I'm trying to customize a slicer. I select the pivot table created and then I select the slicer to show the related properties. So I try to change the size of ...Answered | 15 Replies | 7046 Views | Created by pscorca - Tuesday, June 26, 2012 8:59 PM | Last reply by greta2020 - Monday, June 22, 2020 12:53 AM -
1 Votes
Conditional SUM ISBLANK
Hi, I am getting the data model using a mssql query, if an invoice is canceled the "Estatus" column has the word "Canceled" if not, the column is empty. I am ...Answered | 6 Replies | 814 Views | Created by jparada - Friday, June 19, 2020 5:50 PM | Last reply by jparada - Sunday, June 21, 2020 4:58 AM -
0 Votes
Error Code : 0Xc004f012 again
I was using my computer its reset after I'm assuming an update and its asking me to "Activate Windows" which I attempt to only to be met with the above error ...Unanswered | 1 Replies | 461 Views | Created by متجر نايف - Saturday, June 20, 2020 12:32 PM | Last reply by AV111 - Saturday, June 20, 2020 12:50 PM -
0 Votes
Sum of values in one query based on filter from another Query
= then JobTaskFrom andProposed | 1 Replies | 208 Views | Created by Rune_ - Friday, June 19, 2020 1:17 PM | Last reply by Herbert Seidenberg - Friday, June 19, 2020 11:23 PM -
0 Votes
Type Comparisons - Type.Facets & Type Kind Claims
Hello, Based on the answer to Type Equality, we know that nullable primitive types (including primitive types) will always equal themselves. However, types can also have ...Answered | 4 Replies | 247 Views | Created by Ben Gribaudo - Wednesday, June 10, 2020 9:15 PM | Last reply by Ben Gribaudo - Friday, June 19, 2020 6:34 PM -
0 Votes
Price look up based on time
Hi All: I am trying to look up prices for morning, afternoon, Saturday, Sunday, Public Holidays based on the ShiftStart and ShiftEnd in the fact table. Morning Rate applies from 6AM ...Answered | 3 Replies | 316 Views | Created by M.Awal - Thursday, June 11, 2020 3:25 AM | Last reply by M.Awal - Thursday, June 18, 2020 8:20 PM -
0 Votes
Ocasionalmente ou PowerBI está encerrando inesperadamente. Código de exceção: 0x4000001f
O PowerBI está falhando com o seguinte registro no log de aplicativos. Alguma dica? Nome do aplicativo com falha: ...Unanswered | 5 Replies | 213 Views | Created by Cruiff Pinto - Wednesday, June 10, 2020 10:47 PM | Last reply by Ehren - MSFT - Thursday, June 18, 2020 5:03 PM -
0 Votes
Extracting MetaData from Outlook .msg files within Folder
Good Morning everyone, I've utilised Power Query now for awhile but have never required to do this until recently. I was given a folder of over 600 emails that requires sorting and ... -
0 Votes
Transform large data set in PQ
Table.TransformColumns(state,{current, Text.Trim}) ), EmptyAsNull = ...Proposed | 6 Replies | 411 Views | Created by M.Awal - Sunday, April 5, 2020 4:28 AM | Last reply by M.Awal - Wednesday, June 17, 2020 10:21 AM -
0 Votes
Combine excel files from a folder
Hi : I am trying to combine a number of excel files from a folder ( Data - Get Data - From File - From Folder). After I click on the down arrows in the Content column, in the wizard it only ...Answered | 4 Replies | 278 Views | Created by M.Awal - Thursday, June 4, 2020 9:57 AM | Last reply by M.Awal - Wednesday, June 17, 2020 9:56 AM -
1 Votes
How to read from each file only once during a transformation?
Hello, A well know pattern in Power Query is the creation of a function to perform a transformation in a series of files/tables. I usually do ...Answered | 4 Replies | 283 Views | Created by AndréLz - Sunday, April 12, 2020 11:14 PM | Last reply by anthony34 - Wednesday, June 17, 2020 6:48 AM -
0 Votes
Consecutive loss
I’m trying to calculate the quantity of consecutive loss per hour group, per day, and the max consecutive loss per hour group. I have tried to adapt some formulas for ...Unanswered | 3 Replies | 800 Views | Created by MarceloPenner - Friday, June 5, 2020 3:51 PM | Last reply by Herbert Seidenberg - Wednesday, June 17, 2020 2:50 AM -
0 Votes
Replacing third octet of IP Addresses in Table
I've followings values (IP Addresses) in my Table: 192.168.1.2 192.168.2.88 192.168.1.3 192.168.2.3 I ...Proposed | 2 Replies | 284 Views | Created by Siddique Khan - Monday, June 15, 2020 8:27 AM | Last reply by anthony34 - Tuesday, June 16, 2020 7:03 AM
Power Query announcements
-
Link
Olá
O Power BI Preview está disponível em seis idiomas, mas a documentação e o suporte para o fórum estão atualmente disponíveis apenas em inglês. Você pode usar o www.microsofttranslator.com para traduzir o conteúdo do fórum.
Salut
Power BI Preview est disponible en 6 langues, mais la documentation et le forum d'assistance sont actuellement seulement disponibles en anglais. Vous pouvez utiliser www.microsofttranslator.com pour traduire le contenu du forum.
Hallo
Die Power BI Preview ist in sechs Sprachen verfügbar, aber Dokumentation und Forumunterstützung sind momentan nur auf Englisch verfügbar. Sie koennen www.microsofttranslator.com verwenden, um den Inhalt des Forums zu übersetzen.
Hola
Power BI Preview está disponible en seis idiomas diferentes, pero la documentación y foros de soporte sólo están disponibles en Inglés. Puedes utilizar www.microsofttranslator.com para traducir estos contenidos.
Hello
Power BI Preview is available in six different languages, but the documentation and support forums is only available in English. You can use www.microsofttranslator.com to translate this content.
こんにちは
Power BI Previewは六カ国語にてご提供させていただいていますが、ヘルプとフォーラムなどのサポートは現在英語のみです。あらかじめご了承ください。ヘルプがご必要な場合はwww.microsofttranslator.comの機械翻訳をお試しください。
Power Pivot announcements
-
Link
The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.
We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:
- http://powerpivot.com/download.aspx
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca
Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.
-
Link
If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.
The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.
Kathy MacDonald
SQL Server Analysis Services -
Link
Summary
=============================
If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.
More Information
=============================
The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.
The solution is to upgrade the beta components to their released versions when they become available.
