Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
I'm interested to know about this as well.
Just the other week when I went to the get data tab there was an option to connect directly to my PBI model, however, today that option seems to have disappeared.
Has any body else encountered this issue.
This doesn't work?
File -> Import -> Power Query, Power Pivot, Power View (In February Release) or
File -> Import -> Excel Workbook Contents?
Proud to be a Super User!
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,
@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.
Hello
I have the same problem on my project.
From Excel, I have an extraction of a Power Bi report. However Excel obliges us to have this extraction in a pivot table.
I wish to have this extraction in a simple table.
How did you manage to get around this obstacle?
Hello there,
I was able to extract the data into a tabular format. Here's how you would do it:
>> Pull all of the fields into the Rows well
>> Keep the pivot table selected, to up to Design ribbon > Report Layout > Show in Tabular
>> Design ribbon again > Report Layout > Repeat All Items
>> Design ribbon again > Subtotals > Do Not Show Subtotals
>> Design ribbon again > Grandtotals > Off Rows and Columns
>> Design ribbon again > uncheck Row Headers
After those steps you should have a nice tabular formatted table of data. However, you will still see the collapse buttons on the cells. To get rid of these, I just copy and paste (values) onto another worksheet.
I hope that helps!
Try using macros in Excel. That's the only way I can think of. I don't know too much about macros but I think simple steps like that can be done very easily.
Actually, I've used Power BI connector for Excel add-in with Excel CUBE functions and was able to manipulate the layout of the data in Excel without the Pivot table.
Not so difficult, after all!
😁
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
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.
@webportal,
I can't think of any other methods to achieve the requirement.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |