The idea of copying, pasting, and renaming several dozen measures was less than appealing. Due to the lack of the ability to filter data in Power Map, I had to create several calculated measures in my data model to limit the data shown in my map. Going this route means pasting your measure, renaming the old measure, and then renaming the new copy of the measure to the original name. You can copy the formula from the formula bar and paste it into a cell on another table, but you will get a warning that you can’t have two measures with the same name. You can’t just copy a calculated measure to a new table by cutting and pasting. Rebuild or move any calculated measures to the new table.Rename the new table to the original table name (usually it has a 1 after the table name).Create relationships for the new table to match those of the old table.The issue can be fixed, but it’s a bit tedious: I already had Power View reports built off of my model that I didn’t want to rebuild, and I didn’t want to leave a duplicate table in my model, but I needed to make the data model refreshable. My changes broke the connection between the two tools, so when I refreshed a query in Power Query that was set to load the results to my data model it caused a new/duplicate table to be created in my data model instead of updating the original table. I learned a lesson the hard way: I shouldn’t change field names and data types in Power Pivot on tables that were imported using Power Query.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |