If you found this video helpful, you're going to LOVE my FREE Power BI QuickStart course 👉 link.xelplus.com/yt-c-beginner-powerbi-freecourse It's designed to get you results FAST, without the techy jargon.

Wow this is awesome have been seeing this export but never knew it works magic thank you

Handsome tricks, thanks for posting! Export with live connection option is the best one as it allows data refresh from Excel online, i.e. without opening Excel desktop each time (what a pain). Btw if Excel online could one day allow power query refresh for external data, would make life much easier 🙃

This is cool! But I probably would not let out clients know...we need them to actually utilize the dashboards they requested. 😅

Super cool Leila, I didn't know about this, thanks!

Thank you for teaching

Microsoft-Excel más vivo que nunca !!!! 👍👍

Hi Leila You missed the most useful one which is querying the analysis services on the service for that power bi dataset, That way you can customize the DAX exactly as you want and do any needed transformations such as removing the [ ] from the headers.

That is amazing!!! Thank you 🎉

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?

Thank You., You are the best teacher, i learned lot from watching your channel video.

Thank you, GREAT 👌

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?!

Thank you ma'am 😊

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

Another great video!

Thank you for this

Do we need special license type for "Insert Table" option? My Excel allows me only to add pivot table from PBI dataset.

I pulled various PowerBI stuff into Excel using Analyse in Excel from within PowerBI which I now refresh daily. I’m still learning and hadn’t appreciated the option to create tables using Get Data from within Excel. I’m now wondering if creating tables this way and refreshing those rather than the pivot tables I have from Analyse in Excel is a more efficient way of doing it 🤔 Thanks for the quick tutorial.

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

Hi Mam , I am biggest fan of yours from Pakistan. Your way delivering knowledge is very effective and impressive. I need some help from you, can you please make a video on Time based Quiz making in Excel.

What a delightful video! 😃🎉

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?

Which version can apply insert table, as my verson only pivot option

Good explanations, as usual. But I miss another option, to be able to export or download data from a dasboard embedded on the web. It is still not allowed and I think is the final point to get the best from both worlds, Power BI and Excel. Thank you in any case

Hello Leila. Great video!. After I created the table in excel pulling information from PowerBI how can I add another columns/fields? Thank you!

Which color theme are you using? I really loved that.

I too do not have an Insert table option. Is this version specific? Does it require 64 bit?

It is Amazing.. thank you.. question, there is a way to allow to the users add a comment in the excel and show that comment in the Dashboard?.. by example if the user want explain a big variation of Sales in August 23 Vs July 2023 and he want explain the reason of variation, I really appreciate your help

Thanks, really helpful. Regarding the first option (insert a Table in Excel): once I've done it, and if I want to go back to the query to, say, add a new column, how can I edit the query (all I see is the SQL-like query text)? An advantage of the pivot table approach is that all the fields are available live in the workbook.

Thank you. Is there a way to link powerbi dashboards to excel like your video to that show how to link powerbi dashboard in PowerPoint? I was wondering if there was a way to export a powerbi dashboard to excel.

Superb thanks

Hello Laila, I could not add normal column in value section of Pivot, Is it necessary that it should be only Measures or Calculated field.

Thanks Leila. Is there a way to remove the brackets from the table linked to Power BI?

What version of Office and or Power BI does an organization need to be able to use this function?

Brilliant! The question is how can I see the insert table option. I only see the pivot table option

I am likely not the best person to ask this question as I am still a P-BI rookie. But I thought P-BI was considered the 'best-of-the-best' ... used by Jedi-Knights to fly in the most creative analytic orbits. So ... why return to Excel? What is available in Excel that is not available in P-BI? But ... once again a beautifully presented video, opening doors to possibilites I did not know existed ... 😍😍😍 ... so thank you ... thank you ... thank you. PS For Prof Leila, the default 'table formatting' style is still like fingernails on a chalkboard ... 😂🤣😂 ... and today we have a 'twofer': at the 3:40 mark "But one thing I need to do before that is remove table formatting ... " ...and ... at the 9:40 mark: " ... but first I am going to remove the table style".... 😁

There are 2 other ways to export data. From Power BI Service we can use the XMLA Endpoint through Sql Server Analysis Services. We can generate the DAX query we need in Power BI Desktop. The second was is to export data from an already existent .pbix file by connecting to it with a host number and it will bring the data model to excel.

I would like to know that, how can we build a pivot table month on month should be sum and grand total need as average.. Is there any way to do it ?

Have to look into this. Was disappointed to find I couldn't just grab a query from Power BI in Excel.

Great videos. Any chance you provide private training sessions for specific organizations?

Do yoi use Microsoft Lists? I can't find a video about it im your channel? If not what other app you use insted?

Is it possible to modify the applied filters from PBI in our excel file?

Leila thanks for the video and as always well explained, however in my vesion of excel I don't have the option from power BI. I have the microsoft 365 insider version. are you aware of a delay in the downloads? When I update it says I have the latest version. kind regards Roger

Hello Leila, I am trying to perform this in the company but the issue is that the link is not appearing in "From Power BI (XelPlus). Do you know the reason behind that? Thank you

I am getting the options of Power BI (Xel Plus) in "from power platform" and I am also not getting the option in pivot table

@LeilaGharani I want to rearrange tabular data in different way and Power BI is helpful however my tables contain only texts. While exporting data - I get same data as input while I am looking for view visible on POWER BI. Its Matrix view - can you guide how I can get same view exported in Excel?

I dont have the power bi option when i got to Get Data > Power Platform

Hello, QUERY: In relation to the first solution, one thing I noticed is that if I create an additional column in Power BI then it does not show when refreshing the Excel table/data source in Excel. It's almost as if you have to go to the 'Builder' tab again and include it in the table. The problem is, the only time I can see the 'Builder' is when initially loading the table from the Power BI source. I can't find a way to load it again after that.

Hi Leila, does this consider RLS? because when I tried this solution it was not taking RLS, I mean the excel file would show me all the data, which I do not want. Any other go?

Hi, I am unable to see Insert table option in power BI dataset. I am directly getting power pivot. I want to create customized table in power BI first as it's a huge dataset

Two tables in power bi dataset when I bring into excel doesn’t recognize the relationship I defined in power bi. Is there a work around for it?

this is cool. just have a question. when i extract data from power bi with the Analyse in Excel option some numeric fields (Data type - Decimal) come as text so not allow to put in Values in the pivot table. How to fix it?

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?

Leila, here are my questions/requests (long-time standing): - How can I connect to the data model from a local pbix or even xlsx file? I want to import (part of) a local data model into a new Excel file. (If the data model is in the PBI-cloud we can per your video, but…) How do we do that? Thanks in advance for your response.

My end users cannot refesrh the excel file which connected to dataset in power BI. What should I do to allow them to refresh the latest data? 😢

How can you rename the columns in the table?

Is there a limit on how many rows you can get from this method

Hi, Good morning, i am using 365 Office but from Power Platform is not showing this option? Please Any ideia ? I am trying to link to a file in PBI Desktop

I use this Excel for Microsoft 365 MSO (Version 2306 Build 16.0.16529.20226) 64-bit and i haven't the option to insert a table. automatically is download a pivot table. Why?..

I can't seem to share my excel file to other people. They only need to refresh the excel, but I can't enable them that.

I don't have an option for power bi? I go to Get Data > Power Platform and all that is there is dataflows and dataverse

ma'am I want to paste chart to new worksheet and new chart need to take data reference from new sheet ,,as I have 228 worksheet and 5 chart with 3 data pts in one worksheet to be pasted so it is lengthier kindly give solution

great Video, but I don‘t like these hard-limit-of-rows when connecting/downloading data to Excel 🤨 in a small fancy presentation this works fine, but with a slightly bigger dataset this inevitably leads to an annoying restriction.

I asked chatgpt for top 10 Excel teaching channel 1- ExcelIsFun 2- MyExcelOnline 3- Excel Campus 4- ExcelJet 5- ExcelVbaIsFun 6- Leila Gharani 7- Excel on Fire 8- Excel with Business 9- Excel TV 10- Contextures Inc.

From power plate form > from power bi is nt available in excel 2019

Sir can you please help me that In my excel there is so many names like 500 names and most of the names are repeated so all of total is around 5000 names including all duplicates, but i want to put only remarks for each person and it should reflect in other duplicate cells of each person name. How can i do? I am too much confused and searching alot about this but couldn't find any solution. Can you please help me in this situation please

So I can't do this with the free license, right? 😢

what about the other way around?

I tried to learn Power BI but found the different account options very confusing. I'm also a freelancer and not part of a company so my options seemed to be limited. Apparently I picked the wrong one cause it wouldn't even let me build a working date set. No matter what I tried, it wouldn't work. Asking the folks at the Mr. Excel board didn't help either. I gave up. This option you showed is something that made me interested in giving it another go but when you came to all the settings ad account types etc. I realized I wouldn't bother. I'll stick with Power Pivot and do what I want with it.

No video link in description

@LeilaGharani this was worked for me "perfectly". I missed 2 dimension fields from my dataset, which is a bit annoying as one has to do the whole get data from scratch. However, at some point the tile I now get changed (after Get Data >> From Power Platform >> From Power BI) where you could select either to insert a pivot table or a table. Now I only get tiles of my datasets and at the top it simply says "Select a dataset to create a PivotTable. Your PivotTable will be created in a new worksheet". I am not sure what I have changed that I no longer have the option to inset a table?. Luckily I have been working in a new file to test the functionality, and also saved that. I have been able to copy that sheet to my main forecast file (where I want this functionality in my workbook), but still cant add the new fields I need. The workaround I figured out was to copy the "Command text" under Connection Properties >> Definition to word, adding the fields that I needed and paste it back in. I made some other changes as well to affect the "field / column" order to make a bit more sense and not to simply add the 2 new fields at the end of the table. Do you know how to get it back so that I have the insert table option again? I have seen some solutions on the Web but that is generating a table connection string from double clicking a pivot table, and this cant be the way forward... How long has this functionality been out? I see your video is only 11 days old, and normally you are "first to market" with new features (like Python... I thought you had some insider info well in advance that it was coming, that is why you started learning Python and started a series on that.... ;) ) Thank you for your videos.

I use python programming ...

🖐️🖐️🖐️👍

Fetch from dataflow

U r cute 🥰