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.
-
0 Votes
Left join causing left table row loss
Hello, I am absolutely stumped by this issue and I'm hoping someone can give me a direction to troubleshoot. The issue is that when I do a left outer join in Power Query and then expand the right ...Unanswered | 4 Replies | 72 Views | Created by Broken_Gears - Monday, April 16, 2018 3:39 PM | Last reply by Marcin Staszewski - Wednesday, April 18, 2018 11:16 AM -
0 Votes
DAX for Rolling Average for each category
Hi, I am trying create a DAX measure to calculate the rolling average (Sales) for the last 3 days for each category. Here is my schema ...Proposed | 1 Replies | 55 Views | Created by vidsaf - Tuesday, April 17, 2018 7:27 PM | Last reply by willson yuan - Wednesday, April 18, 2018 7:29 AM -
0 Votes
Exel Power Map commercial use and API
Is there an API for Excel Power Map? Is there one planned? And whether it is possible to use Exel Power Map for commercial purposes. For example, use external ...Proposed | 1 Replies | 59 Views | Created by DmitryVR - Tuesday, April 17, 2018 4:44 PM | Last reply by willson yuan - Wednesday, April 18, 2018 6:30 AM -
3 Votes
SUMX and FILTER function
250000, [Sale],0) and then create a measure that sums up the values in that column ... but I don't like that workaround, I would prefer to pull that data directly from my Sales ...Answered | 8 Replies | 102 Views | Created by Rafael Knuth - Monday, April 16, 2018 9:13 AM | Last reply by Rafael Knuth - Tuesday, April 17, 2018 9:27 AM -
0 Votes
measure DAX
Does anyone knows how can I extract this information: I have Tb1 and Tb2, I need to take one column from tb1 and 1 column from tb2 (divide tb1/tb2 and show it in a new ...Proposed | 3 Replies | 93 Views | Created by Vinicius Aleixo - Sunday, April 15, 2018 10:06 PM | Last reply by willson yuan - Tuesday, April 17, 2018 1:31 AM -
0 Votes
PowerPivot reports are getting loaded very slow very often in SharePoint 2013 - SQL Server 2012
PowerPivot reports in sharepoint site are getting loaded very slow very often in SharePoint 2013 after doing IIS Reset things are okay but after certain time again it will ...Answered | 6 Replies | 969 Views | Created by Cheekoti Ram - Friday, October 17, 2014 5:27 PM | Last reply by Gabe Smith - Monday, April 16, 2018 8:32 PM -
0 Votes
Converting a YAHOO/GOOGLE Historical Stock data Excel Macro to accept BarCode.Com API
Due to some health issues, I am finally looking into redoing my GOOGLE historical data extract (Originally YAHOO) and input the data automatically into my Excel worksheet. I have no clue as to how to ...Unanswered | 6 Replies | 76 Views | Created by Mustang1965 - Sunday, April 15, 2018 11:43 PM | Last reply by Mustang1965 - Monday, April 16, 2018 5:53 PM -
0 Votes
Filter table with If statement
Hi I'm an absolute beginner to Power Query M and have trawled various forums but I haven't found a solution to my problem. I hope this is simple. I have a table that I ...Proposed | 2 Replies | 65 Views | Created by SuebyDoo - Monday, April 16, 2018 9:28 AM | Last reply by Colin Banfield - Monday, April 16, 2018 4:30 PM -
0 Votes
KPI issues using Excel 2016
hello, i am trying to set up a kpi, but am having some issues that i can't find answers to. question #1 - i select an icon style on the KPI dialog box, like the ...Answered | 4 Replies | 934 Views | Created by LadyTester - Saturday, October 24, 2015 6:11 AM | Last reply by FPA-CLA - Monday, April 16, 2018 6:42 AM -
2 Votes
Power query grouping based on criteria
Hi, Thank you in Advance. Need data output based on criteria cells by using power query. Input: 6602 Available Criteria (5 ...Discussion | 17 Replies | 262 Views | Created by sps_dani - Tuesday, April 10, 2018 6:02 AM | Last reply by Colin Banfield - Monday, April 16, 2018 1:30 AM -
1 Votes
Really tough Power Query List Generate Problem
There will sometimes be mutiples branches from the starting point AND along the way. We don't get crazy numbers of permutations ...Proposed | 20 Replies | 290 Views | Created by PQ_slave - Wednesday, March 28, 2018 7:49 PM | Last reply by Imke Feldmann - Sunday, April 15, 2018 8:10 AM -
29 Votes
Using text from a column to call different user created functions
Dear All, Although I have 2 years of M practice I didn't learn how to do this. Could someone please, help me? I have a table in excel ...Proposed | 39 Replies | 381 Views | Created by Stevan Dinu - Friday, February 23, 2018 5:56 AM | Last reply by Imke Feldmann - Sunday, April 15, 2018 7:55 AM -
0 Votes
Merging data from Records to be displayed on a single row
I would appreciate it if someone could help me overcome this challenge. 1. Extract around 100 JSON files from a folder. 2. Each JSON file should be ...Unanswered | 3 Replies | 78 Views | Created by D Sutra - Saturday, April 14, 2018 12:42 AM | Last reply by Imke Feldmann - Sunday, April 15, 2018 7:39 AM -
1 Votes
POST http(s) request with xml content in Power Query
I have a POST http request which works good in HttpRequester (Firefox plugin). I know that it is possible to call POST request in Power Query but cannot find working solution. Here is the original ...Answered | 3 Replies | 4953 Views | Created by pashtetGP - Thursday, June 05, 2014 2:57 PM | Last reply by patoduck - Saturday, April 14, 2018 5:20 PM -
3 Votes
Expression.SyntaxError: Token Comma expected.
Hello, What is wrong with this? let Source = ...Answered | 6 Replies | 88 Views | Created by andy.lev - Friday, April 13, 2018 6:02 PM | Last reply by andy.lev - Friday, April 13, 2018 8:26 PM -
0 Votes
Power BI query to return same-name list results from multiple subsites
We have a SharePoint site that users will create item records as a new subsite with a template. On this template is a list, we'll call List A. There are 90+ of these subsites with the same ...Unanswered | 2 Replies | 57 Views | Created by jjohnson7891 - Friday, April 13, 2018 1:59 PM | Last reply by jjohnson7891 - Friday, April 13, 2018 5:22 PM -
0 Votes
Remove comma to make hyperlink work using PQ and Macro
I have the following VBA code to remove the comma that PQ places when you try to create a hyperlink. The VBA code works perfectly if I step through using F8. However, if I use F5 (run), then the comma ...Unanswered | 5 Replies | 81 Views | Created by Shep123456 - Friday, April 13, 2018 9:09 AM | Last reply by Miguel Escobar - Friday, April 13, 2018 2:40 PM -
1 Votes
Web Scraping
My Query was previously working and something changed over the last week... The web scrape my Query is pulling is loading the mobile version of the website which contains ...Answered | 5 Replies | 197 Views | Created by Justin927 - Friday, December 29, 2017 2:38 AM | Last reply by Miguel Escobar - Friday, April 13, 2018 11:02 AM -
1 Votes
How to fill the gaps in values between dates
1. Sorry for my English. 2. Here is the question. I have gaps in dates, beacause rates set up not every day. 3 tables. 2 ...Answered | 2 Replies | 112 Views | Created by VAV_ - Thursday, April 12, 2018 5:22 PM | Last reply by VAV_ - Friday, April 13, 2018 9:46 AM -
0 Votes
"There is not enough space on the disk" for Power BI Service
Hi team, Today I had a problem with Power BI service. I have a few data sets in Power BI service and schedule refresh for those in Power BI ...Answered | 2 Replies | 82 Views | Created by Tom J Sun - Thursday, April 12, 2018 11:39 PM | Last reply by Tom J Sun - Friday, April 13, 2018 8:54 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.
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.