cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
webportal Member
Member

Connect Excel to a Power BI data model

Hello,

 

Is there any way to connect Excel to Power BI Desktop and importing the Data Model to Power Pivot?

 

With Power BI Publisher for Excel it is possible to connect Excel to Power BI Service and get a live connection, but the data is contained within a Pivot Table. I need to maintain a specific spreadsheet-like layout and it is complicated to create formulas linking to a Pivot Table.

 

Thanks for helping!

5 REPLIES 5
Moderator v-yuezhe-msft
Moderator

Re: Connect Excel to a Power BI data model

@webportal,


Please follow the guide in the blog below to connect to Power BI Desktop data model from Excel.

http://biinsight.com/connect-to-power-bi-desktop-model-from-excel-and-ssms/

Regards,
Lydia

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.
webportal Member
Member

Re: Connect Excel to a Power BI data model

Hi @v-yuezhe-msft thank you for your help.

The post describes a method to connect Excel to PBI Desktop, but the data is available in a Pivot Table only, which is basically the same that Power BI Publsher for Excel Add-in does.

Moderator v-yuezhe-msft
Moderator

Re: Connect Excel to a Power BI data model

@webportal,

I can't think of any other methods to achieve the requirement.

Regards,
Lydia

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.
PhuongTN Frequent Visitor
Frequent Visitor

Re: Connect Excel to a Power BI data model

Hello,

 

@webportal  I'm looking for an answering to the same problem and wondering if you found a solution yet? I would greatly appreciate it if you can share your solution.

 

Thanks,

webportal Member
Member

Re: Connect Excel to a Power BI data model

@PhuongTN  as far as I know there's no solution for this.

You may connect Excel to Power BI Service only and work from there.

 

Hope this helps.