No announcements
Found 1229556 threads
-
16 VotesModification to Power Query results in Power Pivot error upon refresh
The problem is that you then lose all your work in power pivot ( added columns, calculated fields etc) as well as all the resulting pivot tables and charts you ...Answered | 36 Replies | 20521 Views | Created by rickthoward - Friday, March 7, 2014 7:12 PM | Last reply by _Tibo_ - Wednesday, April 29, 2015 7:06 PM
-
1 Votes
Power Pivot crashes upon refresh
My understanding during the time of refresh is that it actually creates a copy of the dataset (this is done so that if the refresh fails, Power Pivot can ...Answered | 3 Replies | 2598 Views | Created by SKashat - Wednesday, October 15, 2014 1:17 AM | Last reply by SKashat - Wednesday, October 15, 2014 11:17 PM -
9 Votes
Power Query Refresh via VBA / Pivots refreshing before query completes.
This is a massive problem for my tool, as it requires to update pivot tables only after Power Queries have run through.Answered | 9 Replies | 24927 Views | Created by ccmd00d - Tuesday, September 16, 2014 5:48 PM | Last reply by Colin Banfield - Thursday, December 3, 2015 3:19 PM -
0 Votes
Automate Power Pivot excel refresh
In the time that has passed has another solution come up to your knowledge that allows this to occur, especially since with Office 365 it appears that Power Query has ...Answered | 5 Replies | 3662 Views | Created by Jim123456789jim - Tuesday, September 27, 2016 11:21 AM | Last reply by accessbuddha - Thursday, September 20, 2018 5:12 PM -
1 Votes
Refresh error when sharing Power Query/Power Pivot generated workbooks.
Instead of making everyone at the organization adopt power query, I simply cut power query out of the process and brought the data directly into power ...Answered | 2 Replies | 1632 Views | Created by dalexan - Thursday, August 13, 2015 5:12 PM | Last reply by dalexan - Monday, August 17, 2015 2:04 PM -
0 Votes
Refresh error when sharing Power Query/Power Pivot generated workbooks.
Hi Dalexan, According to your description, you use power query as data source, but when refreshing the data, you get an error “Class ...Answered | 2 Replies | 1409 Views | Created by dalexan - Thursday, August 13, 2015 3:13 PM | Last reply by dalexan - Monday, August 17, 2015 2:06 PM -
1 Votes
update to power query does not refresh the pivot table
Can you delete the Power Query cache from the Power Query ribbon's Options dialog and retry?Answered | 10 Replies | 4981 Views | Created by satyaV - Tuesday, January 20, 2015 7:47 PM | Last reply by Gil Raviv - Friday, January 23, 2015 10:17 AM -
1 Votes
power pivot refresh
If you are able to utilize Power Pivot for SharePoint, or Power BI in Office 365 when it is out of preview mode, you will be able to schedule data ...Answered | 3 Replies | 3132 Views | Created by Ranvir W - Thursday, August 29, 2013 7:16 AM | Last reply by Melissa Coates - Sunday, September 1, 2013 1:04 AM -
1 Votes
Azure SQL database -> Power Query -> Power Pivot + scheduled data refresh
Regarding the error you get when creating the datasource, it is probably caused by the query string of your Power Query ...Answered | 1 Replies | 1947 Views | Created by Ben_m1 - Tuesday, February 10, 2015 6:45 PM | Last reply by Verónica Bas - Wednesday, March 4, 2015 11:50 AM -
2 Votes
Is there a way to disable Power Query queries and disable the auto refresh of Pivot Tables?
Basically there is some contention between the Power Query (PQ) queries and the Pivot Tables whilst pointing to the same Power Pivot data ...Answered | 1 Replies | 12025 Views | Created by Kieran Patrick Wood - Thursday, May 14, 2015 5:25 PM | Last reply by Kieran Patrick Wood - Friday, May 15, 2015 12:34 PM -
0 Votes
Power Pivot Data Refresh - Share files
You want others to see the data as of the point that you saved the workbook and *not* to automatically refresh upon opening the workbooks.Answered | 2 Replies | 1532 Views | Created by tLkRpt01 - Tuesday, November 25, 2014 1:42 PM | Last reply by tLkRpt01 - Tuesday, November 25, 2014 4:17 PM -
0 Votes
Refreshing Power Pivot pivot table refreshes everything but the pivot table
After new data was add to the data source, and click the Refresh button, it will reflect to Pivot table.Answered | 2 Replies | 1179 Views | Created by TimNoosa - Monday, March 14, 2016 11:42 AM | Last reply by TimNoosa - Monday, April 4, 2016 4:13 AM -
1 Votes
Power BI with Power Pivot and Power Query
2) Does Power BI designer work with Power Query?Answered | 1 Replies | 1549 Views | Created by Urvashi Yadav MS - Tuesday, March 10, 2015 5:44 AM | Last reply by Avi Singh - PowerBIPro - Friday, March 13, 2015 6:38 PM -
0 Votes
Power Pivot does not update from Power Query
⚡Power On!Answered | 2 Replies | 690 Views | Created by Power Query does not update from Power Pivot - Wednesday, October 25, 2017 12:12 PM | Last reply by Avi Singh - PowerBIPro - Tuesday, October 31, 2017 4:04 AM -
0 Votes
Errors in Power Query Refresh
More info on Scheduled Data Refresh: ...Answered | 1 Replies | 1540 Views | Created by Carly K - Thursday, October 30, 2014 4:32 AM | Last reply by Ed Price - MSFT - Sunday, November 16, 2014 10:36 AM -
1 Votes
Power Pivot queries
SSAS can be used as a source for reporting tools (like SSRS) designed to work against a database, thus requiring a table of data normally resulting from a SQL query.Answered | 3 Replies | 1292 Views | Created by AlexMartini - Wednesday, August 3, 2016 8:15 PM | Last reply by AlexMartini - Tuesday, August 23, 2016 6:22 PM -
2 Votes
Power Pivot data refresh in Office 365
Hi Grace, Couple of questions: Do you see a reference to the refresh on the Power BI Admin center under system health?Answered | 4 Replies | 2173 Views | Created by Grace M - Friday, March 21, 2014 2:08 PM | Last reply by Grace M - Thursday, April 10, 2014 11:34 AM -
0 Votes
Power Pivot Refresh issue
Hi Everyone, I have a Power pivot report connects to SQL Cube, when i refresh the Pivot it is working fine for me, however ...Answered | 1 Replies | 1157 Views | Created by addakulakishor - Friday, August 18, 2017 7:52 AM | Last reply by willson yuan - Friday, August 18, 2017 8:11 AM -
7 Votes
Incremental or scheduled power query refresh
Currently, there is no support for incremental refresh in Power Query or Power BI Desktop (besides the workaround that you mention based on ...Answered | 7 Replies | 4156 Views | Created by masplin - Thursday, December 3, 2015 4:17 PM | Last reply by masplin - Thursday, December 10, 2015 12:59 PM -
0 Votes
Power Query Results Not Refreshing Table
Have you try to duplicate your query?Answered | 1 Replies | 489 Views | Created by _todd_ - Tuesday, June 18, 2019 12:22 PM | Last reply by anthony34 - Tuesday, June 18, 2019 2:24 PM - Items 1 to 20 of 1229556 Next ›
No announcements
