I spent 2 years on a client to reduce dependency on Excel and trained them to do Ad-hoc analytics in Power BI (Your videos helped a lot in the process), Now this :P
Do we need special license type for "Insert Table" option? My Excel allows me only to add pivot table from PBI dataset.
Thank you very much for sharing this knowledge, very useful. When I go to 'Get Data' and select from Power BI, I get only the option to a pivot table and don't have the option to get it in table as you had. Do you have any idea why? I work with the following excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20684) 64-bit
Which version can apply insert table, as my verson only pivot option
Thanks for sharing Leila! I want and need this now but I don't currently have the ability to "Insert Table" just yet, so I am guessing this capability will be added at a later date?!
great videos, thank you
This video is a life savior, as my boss seems be data blind to anything other than Excel spreadsheets 🙃 Thanks a lot!
Thank You., You are the best teacher, i learned lot from watching your channel video.
I too do not have an Insert table option. Is this version specific? Does it require 64 bit?
At 1:16 the Get Data menu has "From Power Platform" as an option, but I don't have that option. I just have "From Power BI." When I choose it, I don't get the option to insert a table. Is this because I am on an older version of Excel?
When I try to import data from a Power BI Dataset I am not presented with the options of + Insert Pivot Table or + Insert Table. I'm only provided a list of Datasets available from our Work Spaces (Promoted and not Promoted) with the header that states, "Select a dataset to create a PivotTable. Your PivotTable will be created in a new worksheet." I have checked with our IT department and I have all the permissions necessary to be able to + Insert Table. I am also running Microsoft 365. Any ideas as to why this option is not available to me?
Another great video!
Thanks for this but how can I edit the filter after creating a table? For example I have this months in the filter, but the month after I have to change the month sales
This video is an absolute lifesaver! I also noticed that the table order in Excel differs from how I arranged them in Power Query. How can I ensure they retain my preferred order when opening them in Excel? Thanks so much!
Brilliant! The question is how can I see the insert table option. I only see the pivot table option
What version of Office and or Power BI does an organization need to be able to use this function?
Love you 😍 I found new way of approach I was expecting long ago
Fantastic vid, thank you! How can I export all the data of the report (as xlsx, or csv) rather than export the data just for a specific visual?
Can I add another measure in the same table after created it?
@LeilaGharani