cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
redbaron
New Member

Change existing PivotTable Connection

Good morning Guys,

 

There is a way to change a existing connection (ODBC) of a PivotTable in Excel to Power BI? I tried the traditional method but I get this error: "You cannot choose a connection file that is incompatible with the existing connection. excel"

 

thanks in advance.

3 REPLIES 3
redbaron
New Member

Change PivotTable existing connection to PowerBI

Good morning Guys,

 

There is a way to change a existing connection (ODBC) of a PivotTable in Excel to Power BI? I tried the traditional method but I get this error: "You cannot choose a connection file that is incompatible with the existing connection. excel"

 

thanks in advance.

Moderator v-yuezhe-msft
Moderator

Re: Change existing PivotTable Connection

Hi @redbaron,

Based on your description, you want to change PivotTable data source in Excel. As the issue is more related to Excel, I would recommend you post the question in the Excel IT Pro Discussions forum to get dedicated support.

In addition, in Power BI, there is a feature called Analyze in Excel. With Analyze in Excel, you can view and interact with a dataset you have access to in Power BI, and thereby access PivotTable, chart, and slicer features directly in Excel. If you want to create PivotTable for Power BI dataset, you can use the Analyze in Excel feature, for more details, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/ .

Morover, you are able to pin pivottable from Excel to Power BI dashboard following the instructions in this article.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
redbaron
New Member

Re: Change existing PivotTable Connection

Hi Lydia, thanks for your help!! I know there is a option "Analyze in Excel". A customer has several reports that use Oracle data with ODBC connections. I want to replace existing connections with the ODC file connection created using Analyze in Excel option. I will follow your suggestion and will go to Excel forum.

 

Thanks again.

 

David.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors