10 июля 2012 г. 0:34
I have created a powerpivot data model with tons of measures & KPIs. Originally the source of my data models were .csv text files. To make auto refreshing work better, I migrated all the underlying tables & schema to a SQL Server DB (ensuring the schema remains exactly the same as the text files). Now I am trying to point my data model from the text file source to SQL db connection. I am not sure how to do that other than laboriously re-creating the data model manually. When I go to "existing connections" and edit a text connection, I dont see any option to change to SQL server connection.
4 апреля 2013 г. 10:20
You have to add another connection its obviously not existing. Also, just to be clear or so we are on the same page, you used an ODC file for all of your connection information and you did not store the logic embedded in Excel.
- You opened SSM
- Created a new DB
- Right Clicked the New DB and Chose Import Data > Flat File > Column Names in in First Row of Data
- Then previewed the result ? Click next and you didn't have any errors
I have changed data sources in SQL and using an ODC. But I have never attempted to change a data source embed within Excel. You should be able to clean up the data source information doing a search and replace. But again I always use ODC files when working with Excel and Visio so that I can distribute them for other folks to use and make any changes necessary to the data source.
- Предложено в качестве ответа Jacob Barnett 18 апреля 2013 г. 4:24
17 апреля 2013 г. 3:40
18 апреля 2013 г. 4:07Thanks Ivan. It worked and this can be closed.
18 апреля 2013 г. 4:18Then you should mark the post as the answer!