You’re offline. This is a read only version of the page.
4
Hi, For security reasons beyond my control we're not permitted to directly query our SQL server database. Instead we have to query the sql database via Access, usually using passthrough queries for efficiency. Various Excel workbooks then connect to Access to load the query results. This works well as all our queries are in central location.
What I'm stuggling with is using a passthrough query as a source for Power Pivot; I get a this table can't be found error. I know I can connect to the passthrough query and output into an excel table and then subsequently use that table as a source but I'd prefer to just load the passthrough query into the data model. I feel like this should be achievable and I'm just missing something simple but at the same time I get the feeling that Power Pivot itself wants to be the one to load and query all the tables internally.
Can anyone suggest what I need to do get Power Pivot to do what it's told and use the results of the existing passthrough query as the source?
Note: advised to post here from answers.microsoft.com
Share
Report
All responses (
Answers (
