cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BlueNote
Frequent Visitor

Converting Power Pivot Pivot Tables to a Power BI (Analyze in Excel) connection

Hi Everyone,

 

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.

 

Any help with this would be greatly appreciated.

 

 

1 REPLY 1
GilbertQ
Super User
Super User

Hi @BlueNote 

 

As far as I know you cannot point to the Power Pivot Model. All the data now sits within Power BI.


What you would have to do is to re-create those tables/visuals cube functions pointing to the data in the Power BI Service.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors