Converting Power Pivot Pivot Tables to a Power BI (Analyze in Excel) connection
I want to point my Power Pivot based pivot tables to a Power BI (Analyze in Excel) connection string in order to reuse them and avoid having to duplicate the effort of recreating them again with the new connection.
I imported the Power Pivot model into Power BI using the desktop tool (File>Import >Power Pivot, Power Query, Power View) which went flawlessly. I fixed up the Power Query stuff a bit and then publised to the Service and made an App. I exported the Analyze in excel file from the App and it works great. I was able to move the Analyze in Execl worksheet over to my old Power Pivot Excel Workbook to bring the new connection in. I have some sheets that utilize cube functions and I can change the first argument to point to the new azure source string and they work. However I'd like to also point the Power Pivot model based Pivot tables (and slicers) if possible to the Power BI service connection string too. Not sure if this is even possible but cannot find anything on Google.