![]() This can be done by disabling and re-enabling download of ‘Macro photography lenses’ in Power Query. OLE DB or ODBC error: The query ‘Macro photography lenses’ or one of its inputs was modified in Power Query after this connection was added. The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source. If you’re working with Excel Power BI tools you’ll eventually see this error. This will always happen anytime we make any kind of change to a Power Query that is connected to a Power Pivot table. Open the Power Pivot window, there is only one table, let’s refresh it. This should be easy, just open the Power Query (in the example file) named, “Macro photography lenses”, and delete the “RemovedColumns” step and the “Closest Focus” column should now be back. This is the Power Pivot table that requires an additional field In this example a Business Manager wants me to add the field, “Closest Focus” to the Power Pivot table. If you want to follow along download the file below, I’ve used some public data on camera lenses so anyone can refresh the data model (use Anonymous access if prompted), or follow along just using the pictures. Just playing around on a hunch, I figured out a way to fix it without having to rebuild the model!!! Some already know the “fix”, for those that don’t, I’ll walk through the method that’s been working for me. Most threads end with no, you just can’t do that. I’ve searched the far reaches of Google, only to find a lot of threads asking about how to fix, but I’ve never seen an answer. I’m going to have to change my Power Query which is going to break my Power Pivot connection, and then I’ll be spending hours to rebuild my model from scratch! Then I show it to the Business Manager that requested it, and he wants me to add a field that I didn’t pull in through Power Query. ![]() ![]() It’s the same old story, I mashed and twisted some data through Power Query, pulled it through Power Pivot, spent hours creating calculated columns and measures, made a really nice Pivot Table with conditional formatting and all the bells and whistles. Note, this fix to re-establish a broken connection is performed using Excel 2010
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |