locked
Add predefined .ODC files for PowerPivot users RRS feed

  • Question

  • Hello Experts,

    We dynamically create .ODC files for Excel pivot table connections to SSAS databases. Those are published in SharePoint and the library path is configured in client profiles through a registry key set at logon. That way users can browse existing connections with friendly names without having to remember technical details when initiating a connection.

    We'd like to do the same with the existing connections in PowerPivot (stand alone in Professionnal edition) so users can access relationnal data in a self-service orientation, but it doesn't seem to work the same way.

    The connections physical locations don't seem to be the same as they are directly in Excel. The network connections option is not available, and the local connections don't seem to point to the MyDataSources folder / Office Queries folder as in Excel. The ideal solution would be to be able to deploy .ODC files in a shared location and simply add the path to this location through registry manipulation at logon.

    Any ideas ?

    Thanks !

    Tuesday, September 16, 2014 5:41 PM

Answers

  • Though I cannot answer your question, I would be interested to know more about your current solution to publish connection files. 
    Would you share details ? ( scripts, registry key...etc) 

    Regards,


    Thursday, January 15, 2015 9:48 AM

All replies

  • Any suggestions for Djobin?

    Thanks!


    Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Wednesday, October 1, 2014 11:15 PM
  • Thank you Ed for the follow up, seems like nobody uses PowerPivot in a corporate environment ;) I tought questions about Power BI tools would have more appeal, makes one wondering about the choices me made... A Microsoft Premier Support BI specialist is about to visit us, I'll make sure to ask her the question.

    Thank you, D

    Wednesday, October 22, 2014 8:06 PM
  • Thank you Ed for the follow up, seems like nobody uses PowerPivot in a corporate environment ;) I tought questions about Power BI tools would have more appeal, makes one wondering about the choices me made... A Microsoft Premier Support BI specialist is about to visit us, I'll make sure to ask her the question.

    Thank you, D

    Ha! A lot of people do.

    Let us know how the visit goes!


    Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Thursday, October 23, 2014 10:32 PM
  • Hi Ed,

    Just so you know, the Microsoft Expert didn't know the anwser either !

    Seems like nobody knows where the PowerPivot Local Connections are stored locally, we're still in the dark...

    Thanks anyway,

    D

    Wednesday, January 14, 2015 3:00 PM
  • Though I cannot answer your question, I would be interested to know more about your current solution to publish connection files. 
    Would you share details ? ( scripts, registry key...etc) 

    Regards,


    Thursday, January 15, 2015 9:48 AM
  • Any luck finding the files?

    Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Thursday, February 12, 2015 8:21 PM