cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
MarkWeisman

2 Actions Needed to Refresh Excel Power Pivot Data Model

Submitted by MarkWeisman on โ€Ž04-05-2017 08:08 AM

Need 1 action for Excel documents stored on PC and 1 for Excel documents stored in a OneDrive for Business or SharePoint document library.

Status: New
4 Comments (4 New)
Comments
MarkWeisman
MarkWeisman
Level: Powered On
โ€Ž04-05-2017 09:28 AM

 Of course, there should be provisions to identify a gateway (personal or enterprise) for the on-premises data sources (e.g., Teradata) needed to refresh the Power Pivot model.

NVB
NVB
Level: Powered On
โ€Ž11-27-2017 05:18 AM

 Not just Power Pivot data, but just regular PowerQuery as well!

freder1ck
freder1ck
Level: Powered On
โ€Ž07-09-2018 11:08 AM

So, I would expect this action to be something like this: open the file, refresh all sources, and save.

dfish00
dfish00
Level: Power Up
โ€Ž12-28-2018 09:16 AM

Ok. So, how? would your Power Query  / Power Pivot Query point to a data source based upon data gateway? I am trying to understand how permissions would be/could be handled? Has anyone actually done this successfully that has a snapshot of a flow and other pertinent details to successfully accomplish this that they could share? In my experience, the advent of the new Power query & Power Pivot tools while nice tool have seemingly made it virtually impossible to do any any automation of Excel based reports with external connections due to the lack of any viable way that I am aware of to pass credentials to the connection upon vba refresh of the workbook.