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.
Power View announcements
-
Link
We are happy to announce that Power View for Office / Office 365 has it's own forum! Power View allows you to analyze and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device! As you do that - you may have questions / feedback / tips to share. Please utilize this forum to share/gain knowledge and expertise in Power View.
We look forward to hearing how you are using Power View and what challenges and suggestions you may have. The more you share, the more the forum can help you get the most out of Power View now and you can influence the next version!
The Power View Team
Power View announcements
-
Link
We are happy to announce that Power View for Office / Office 365 has it's own forum! Power View allows you to analyze and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device! As you do that - you may have questions / feedback / tips to share. Please utilize this forum to share/gain knowledge and expertise in Power View.
We look forward to hearing how you are using Power View and what challenges and suggestions you may have. The more you share, the more the forum can help you get the most out of Power View now and you can influence the next version!
The Power View Team
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.
Power BI Dashboard Preview announcements
-
Link
PowerBI forums are moving to a new site. Please redirect to below url to create new threads.
Please note PowerBI forums will be locked and readonly in the near future. We do sincerely apologize for the inconvenience this may have caused you.
-
2 VotesM Table.Join
The documentation for Power Query covers the basic stuff but there are a lot of inexcusable, frustrating gaps. For example, I want to do a Table.Join and use a comparer to do a ...Answered | 3 Replies | 92 Views | Created by Cool.Blue - Wednesday, June 14, 2017 8:27 AM | Last reply by Imke Feldmann - Sunday, June 25, 2017 6:16 AM
-
0 Votes
Point a query result to a specific range
How do i get Get and Transform to populate a specific range in a worksheet? Can I specify a target range name or top left cell for the result to land in, or define the range as ...Proposed | 1 Replies | 58 Views | Created by 4046 - Saturday, June 24, 2017 8:55 AM | Last reply by Matt Allington - Sunday, June 25, 2017 12:43 AM -
1 Votes
Can I use Power query's for this calculations?
I’ve an excel workbook with thermodynamic calculations. The workbook calculates several heat transfers and temperatures based on external temperatures, obtained from a ...Proposed | 5 Replies | 119 Views | Created by Aart van Hell - Friday, June 02, 2017 7:31 PM | Last reply by Herbert Seidenberg - Saturday, June 24, 2017 5:23 PM -
0 Votes
SAMEPERIODLAST doesn't works for me !!
helllo, I compare % evolution between 2014 and 2017 from 2014 to 2016 all (%) evolution is corrrent but between 2016 and 2017 i get an issue, ...Unanswered | 9 Replies | 191 Views | Created by ghilasdz - Tuesday, June 20, 2017 7:45 AM | Last reply by ghilasdz - Saturday, June 24, 2017 10:26 AM -
0 Votes
Unexpected error: Operation is not valid due to the current state of the object.
fnWeek_Name can be successfully invoked if either "Week 1" or "Week 2" or "Week 3" is entered as an argument. fnWeek_Name produces an Operation is not ...Answered | 1 Replies | 40 Views | Created by D Bliss - Tuesday, June 20, 2017 12:18 PM | Last reply by Ehren - MSFT - Friday, June 23, 2017 11:35 PM -
0 Votes
How to programmatically add HTTP headers along with a URL
Hi there. I'm successfully retrieving data from a REST API endpoint when I do it manually, but I can't find a way to dynamically change the headers. This is what I need to be able ...Proposed | 1 Replies | 159 Views | Created by dpiret - Monday, June 19, 2017 8:34 AM | Last reply by Ehren - MSFT - Friday, June 23, 2017 11:33 PM -
0 Votes
Text in Date Column
Hello All, I am pulling in a query from a source file that I know from time to time will have an A after a date in random cells in random columns. This of course causes an ...Proposed | 1 Replies | 46 Views | Created by sos7 - Friday, June 23, 2017 5:28 PM | Last reply by Colin Banfield - Friday, June 23, 2017 7:02 PM -
0 Votes
Xml.Tables returning table instead of null value
Quick description on what is being done. Maybe I need to do a different approach. So basically in SQL some dynamic tables are stored as a column that is in ...Proposed | 4 Replies | 101 Views | Created by Exanimis - Tuesday, May 09, 2017 10:00 AM | Last reply by Imke Feldmann - Friday, June 23, 2017 5:36 PM -
0 Votes
how to display decimals for amount and 0decimal points for total hours in line and stacked column chart
thousands. so total hours also shoing in thousands format.how to restrict this ,hours should show as it is like `7.5 Please ...Answered | 1 Replies | 39 Views | Created by LuckyLucky12 - Wednesday, June 21, 2017 9:50 AM | Last reply by Imke Feldmann - Friday, June 23, 2017 5:25 PM -
4 Votes
Merging Queries - some rows disappear when expanding merged query
Hi there, Have got a bit of an issue when I merge 2 of my queries and then expand the columns out. This is described below: 1) I merge 2 queries and Power Query ...Answered | 9 Replies | 982 Views | Created by brian_g99.29848185 - Friday, December 18, 2015 7:20 PM | Last reply by Az_Iz - Friday, June 23, 2017 2:16 PM -
0 Votes
Grand Total Column Not Averaging Right
I want to average the numbers in the pivot table by year liek you see below, but the Grand total column should say the average of all the years and it does not. It says it is summarizing by average. ...Unanswered | 1 Replies | 102 Views | Created by Hannah Hammeren - Wednesday, June 21, 2017 7:28 PM | Last reply by willson yuan - Thursday, June 22, 2017 7:49 AM -
0 Votes
A circular dependency was detected
Hi Guys, I get the error A circular dependency was detected: ...Unanswered | 2 Replies | 106 Views | Created by J.Stoffels - Wednesday, June 21, 2017 7:46 AM | Last reply by willson yuan - Thursday, June 22, 2017 4:41 AM -
0 Votes
MS Excel Power Query not refresh if file is not open when choosing Refresh every x minutes
I'm using MS Excel 2013 with Power Query add-in. I have a table with data source from Oracle. Everything is ok - I can manually refresh the data, etc. Then I want ... -
1 Votes
How to disable update notifications for Power Query?
Is there a way to disable the notification of available updates for Power Query? Command line switch on install, anything? Thanks!Answered | 9 Replies | 2855 Views | Created by neimadpc - Friday, July 11, 2014 6:36 PM | Last reply by rsrajeev - Wednesday, June 21, 2017 1:37 PM -
0 Votes
Query data into excel
0,if(SUM([Vuln_Device_Count])>0,1-(DIVIDE(SUM([Vuln_Device_Count]),SUM([Device_Count]),1)),1),BLANK()) into a custom column in the query editor and also using "GVSM Trend Score" ...Answered | 1 Replies | 50 Views | Created by Dipo Thomas - Monday, June 19, 2017 7:38 PM | Last reply by Maxim Zelensky - Wednesday, June 21, 2017 10:04 AM -
0 Votes
how to split a column based on alphabets and numbers
hi all i have a column names description of type text ..i have data as ...Proposed | 1 Replies | 36 Views | Created by LuckyLucky12 - Tuesday, June 20, 2017 7:30 AM | Last reply by Colin Banfield - Tuesday, June 20, 2017 7:14 PM -
0 Votes
how to whether the first character is number/alphabet in a column
hi all, i have a column with ...Proposed | 2 Replies | 50 Views | Created by LuckyLucky12 - Tuesday, June 20, 2017 7:33 AM | Last reply by Colin Banfield - Tuesday, June 20, 2017 6:55 PM -
0 Votes
PQ Bug? Pivot with slicers won't refresh if source data loaded to data model via PQ
I'm posting this under Power Query because this Pivot Table issue is only happening to me on Pivots that are made from the Power Pivot data model where the data was loaded to the model via ...Answered | 14 Replies | 579 Views | Created by tmacg7 - Monday, February 13, 2017 6:42 PM | Last reply by Steven VD123 - Tuesday, June 20, 2017 2:09 PM -
0 Votes
Power Query Not Updating New Access Queries
I connected to an Access Database using Power Query. Initially, I only had 3 tables within the Database. I've have added some queries to the Access Database but when I open Power Query I only see the ...Proposed | 6 Replies | 292 Views | Created by 2stew - Wednesday, June 14, 2017 12:53 PM | Last reply by 2stew - Monday, June 19, 2017 11:38 PM
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.
Power View announcements
-
Link
We are happy to announce that Power View for Office / Office 365 has it's own forum! Power View allows you to analyze and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device! As you do that - you may have questions / feedback / tips to share. Please utilize this forum to share/gain knowledge and expertise in Power View.
We look forward to hearing how you are using Power View and what challenges and suggestions you may have. The more you share, the more the forum can help you get the most out of Power View now and you can influence the next version!
The Power View Team
Power View announcements
-
Link
We are happy to announce that Power View for Office / Office 365 has it's own forum! Power View allows you to analyze and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device! As you do that - you may have questions / feedback / tips to share. Please utilize this forum to share/gain knowledge and expertise in Power View.
We look forward to hearing how you are using Power View and what challenges and suggestions you may have. The more you share, the more the forum can help you get the most out of Power View now and you can influence the next version!
The Power View Team
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.
Power BI Dashboard Preview announcements
-
Link
PowerBI forums are moving to a new site. Please redirect to below url to create new threads.
Please note PowerBI forums will be locked and readonly in the near future. We do sincerely apologize for the inconvenience this may have caused you.
