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.
Is it possible to have the pbix sample file used for this video, so that we can have a hands on try out. Information from your channel is really good, the talking speed is appropriate and clear, easy to be understood for those whose mother language is not English. Thanks
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
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.
@@roberth8546 Late update here - I found that I didn't have the insert table option in the desktop app, but I did have it on the web. Once I added the table via the web, I could use it on the desktop :)
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
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?!
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.
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 🙃
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?
I'm finding that i have some luck bringing data in from a 'Dataflow'. But still, I don't have a good answer to why this isn't working the way Leila describes. @@TiNmyJ
I really liked your video is very easy to understand. I have tried all of the different ways to export from my PBI to excel, and although I am successful in exporting the information, I noticed the totals for all my columns are not the same. I need the information that I have in power BIM for some reason I’m getting multiple rows in Excel. The problem I have is I am reporting on actual hours versus forecasted hours for employees, and the actual hours reported for employees is by an activity code and because there are different hours reported for the different activity codes I have several rows of information for each, and I only need one row of information for the forecast information. The forecast information needs to be by person. However, I need to display the activity so as a result, it repeats the forecast information for each activity. That’s OK for the actual hours, but not for the forecast information. Somehow I got this to work and power and the results are perfect in PBI, no matter what way I try I am unable to get the same results in Excel. Do you have any ideas of how I can make this work? I need this information and Excel for various reasons. Thank you so much for your help.
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.
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.
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
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.
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
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?
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".... 😁
I think having the ability to connect to PBI datasets in Excel allows more people in the business to have the option to do some quick ad-hoc analysis that the PBI report might not have built into it's design. Eg, Dave says, "the report shows me sales over time split by product type but I need to see it split by customer for a call I have this afternooon." If Dave is going to need this on a regular basis, he can find out which developer or team owns the PBI report, ask them to add this functionality to the report and it will go into that person's CI/CD dev workflow/to-do list. And it may get done at some point. In the meantime, if Dave knows what he's doing and has the right permissions, he can connect to the dataset in Excel and get the answers for himself and look like a superstar on his call. In short, it offers flexibility to an organisation, IF they want it. Re: your PS, I love how much Leila hates the default table formatting. 🤣
Many thanks Chris - Agree with @paulgallagher2987 on the advantages of the ad-hoc use of Excel for quick analysis. And yes, that default Table formatting just got worse with the new office theme 🙈
If my business doesn't have the PowerBi workspace services, is there a way to connect to excel as live data? I do excel to powerbi as a live connection but I am not sure it can be done the other way. I have been copying the output table and pasting in excel.
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?
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?
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.
I share visualizations with customers, but I don't want them to be able to see the semantic model when they choose to export to excel. I'd like them to be able to export to excel only the data present in the visualization. Is this possible?
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?..
@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?
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
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
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
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.
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
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
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
Simply get the unique list of the name using the UNIQUE function, write your remark next to it, and vlookup it in your original table with repeating names
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.
Thank you! A question: I’ve already used “insert pivot table from Pbi” option but I have a problem: I do not see all the dataset of our tennant (I am the owner of all the reports/dataset). There is some settings to fix? For now I go to the report in the service and use “analyse with excel” but I would preferred start from 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.
Hi Geert - do you mean connecting an Excel file to the local Power BI desktop? If yes, I don't believe this is possible unless it's a published data model.
Great video explanation as always. For Geert’s specific question, there’s a way to do it. It’s not as smooth as the solution explained in the video, but we can connect separately and discuss how to share the process.
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.
I am also in a simular situation. Power Query and Power Pivot are realy powerful tools now add to that Python in Excel with all its chart libraries and you aren't that far away from Power BI.
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.
This video was fantastic. When “creating a table in excel linked to power bi” is there a way to go back and make adjustments (like adding other values or measures from the power bi data source) after the table is made?
@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.
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.
Is it possible to have the pbix sample file used for this video, so that we can have a hands on try out.
Information from your channel is really good, the talking speed is appropriate and clear, easy to be understood for those whose mother language is not English. Thanks
This video is a life savior, as my boss seems be data blind to anything other than Excel spreadsheets 🙃
Thanks a lot!
Our pleasure!
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
There is no way out of Excel. No matter how good your solution, people will ask for it.
This is cool! But I probably would not let out clients know...we need them to actually utilize the dashboards they requested. 😅
Hilarious! Let’s keep this top secret.
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.
Do we need special license type for "Insert Table" option? My Excel allows me only to add pivot table from PBI dataset.
I'm here wondering the same thing :(
@LeilaGharani Is there an answer to this? Several of us are wondering
@@roberth8546 Late update here - I found that I didn't have the insert table option in the desktop app, but I did have it on the web. Once I added the table via the web, I could use it on the desktop :)
Are you guys using office 2021? If not, thats the cause😊
@@anuragsaini1683 office 365
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
I'm with you. Don't see the option to insert just a table. Did you ever figure out why?
@roberth8546
Not yet unfortunately, but I guess it's related to the Excel version
Thanks, this has all the PBI-excel related information I was looking for 👍❤
Which version can apply insert table, as my verson only pivot option
Same limitation here. My Excel just create a dynamic table... so struggling
I too do not have an Insert table option. Is this version specific? Does it require 64 bit?
Having the same issue, please help. Thanks.
I'm having the same issue, I hope somebody can help!
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?!
Excellent content Leila.
Thank You., You are the best teacher, i learned lot from watching your channel video.
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.
Yes, would love if had option for Table filter in headers to change the underlying DAX/SQL code
It's kind of annoying that you can't change the query in an easy way. I don't like this at all.
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 🙃
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?
I have the same issue and can't find a solution either .
I'm finding that i have some luck bringing data in from a 'Dataflow'. But still, I don't have a good answer to why this isn't working the way Leila describes. @@TiNmyJ
Brilliant!
The question is how can I see the insert table option. I only see the pivot table option
I really liked your video is very easy to understand. I have tried all of the different ways to export from my PBI to excel, and although I am successful in exporting the information, I noticed the totals for all my columns are not the same. I need the information that I have in power BIM for some reason I’m getting multiple rows in Excel. The problem I have is I am reporting on actual hours versus forecasted hours for employees, and the actual hours reported for employees is by an activity code and because there are different hours reported for the different activity codes I have several rows of information for each, and I only need one row of information for the forecast information. The forecast information needs to be by person. However, I need to display the activity so as a result, it repeats the forecast information for each activity. That’s OK for the actual hours, but not for the forecast information. Somehow I got this to work and power and the results are perfect in PBI, no matter what way I try I am unable to get the same results in Excel. Do you have any ideas of how I can make this work? I need this information and Excel for various reasons. Thank you so much for your help.
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?
DAX STUDIO, PYTHON SCRIPT
Microsoft-Excel más vivo que nunca !!!!
👍👍
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.
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.
Thanks a lot
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
I dont have the power bi option when i got to Get Data > Power Platform
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.
What is a host number?
Another great video!
Wow this is awesome have been seeing this export but never knew it works magic thank you
What version of Office and or Power BI does an organization need to be able to use this function?
Thank you for teaching
Can I add another measure in the same table after created it?
Super cool Leila, I didn't know about this, thanks!
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 Leila. Is there a way to remove the brackets from the table linked to Power BI?
How do you modify the table to add additional columns?
Have to look into this. Was disappointed to find I couldn't just grab a query from Power BI in Excel.
Awesome..thank you
What a delightful video! 😃🎉
Thank you! 😃
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?
That is my guess. I have the same issue.
Having the same issue, please help. Thanks.
Hi, when i use this option in Excel, my numerical and Date data come as a string but is already numerical and date data type in power bı data model
Thank you, GREAT 👌
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".... 😁
I think having the ability to connect to PBI datasets in Excel allows more people in the business to have the option to do some quick ad-hoc analysis that the PBI report might not have built into it's design.
Eg, Dave says, "the report shows me sales over time split by product type but I need to see it split by customer for a call I have this afternooon." If Dave is going to need this on a regular basis, he can find out which developer or team owns the PBI report, ask them to add this functionality to the report and it will go into that person's CI/CD dev workflow/to-do list. And it may get done at some point.
In the meantime, if Dave knows what he's doing and has the right permissions, he can connect to the dataset in Excel and get the answers for himself and look like a superstar on his call.
In short, it offers flexibility to an organisation, IF they want it.
Re: your PS, I love how much Leila hates the default table formatting. 🤣
Many thanks Chris - Agree with @paulgallagher2987 on the advantages of the ad-hoc use of Excel for quick analysis. And yes, that default Table formatting just got worse with the new office theme 🙈
If my business doesn't have the PowerBi workspace services, is there a way to connect to excel as live data? I do excel to powerbi as a live connection but I am not sure it can be done the other way. I have been copying the output table and pasting in excel.
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
Thank you for this
Thank you ma'am 😊
Hi Leila! Excel has depreciated the get data from Power BI. Do you have an alternative solution?
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?
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?
@leilaGharani
Which color theme are you using? I really loved that.
I need the get data based on the date range I put in Cell range. how can we do that??
Is there a limit on how many rows you can get from this method
Nevermind I tried this. It sucks if you have a lot of data.
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.
I share visualizations with customers, but I don't want them to be able to see the semantic model when they choose to export to excel. I'd like them to be able to export to excel only the data present in the visualization. Is this possible?
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.
That is amazing!!! Thank you 🎉
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?..
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? 😢
When updating the data in Excel I am always asked for the account, in your Video not, why?
Superb thanks
Most welcome 😊
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.
@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?
Is it possible to modify the applied filters from PBI in our excel file?
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 ?
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?
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
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
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
How can you rename the columns in the table?
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
Great videos. Any chance you provide private training sessions for specific organizations?
Glad you like them. Currently we don't offer private sessions. However, we do offer corporate rates for our courses on XelPlus.
Hello Leila. Great video!. After I created the table in excel pulling information from PowerBI how can I add another columns/fields? Thank you!
go to properties, definition and change the command text to bring in what you need.
Do yoi use Microsoft Lists? I can't find a video about it im your channel? If not what other app you use insted?
From power plate form > from power bi is nt available in excel 2019
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.
go to properties, definition and change the command text to bring in what you need.
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
Agreed, what version of Excel are you using for 'Table'.
PS that is super sweet version!!!
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
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
Simply get the unique list of the name using the UNIQUE function, write your remark next to it, and vlookup it in your original table with repeating names
So I can't do this with the free license, right? 😢
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.
Thank you! A question: I’ve already used “insert pivot table from Pbi” option but I have a problem: I do not see all the dataset of our tennant (I am the owner of all the reports/dataset). There is some settings to fix? For now I go to the report in the service and use “analyse with excel” but I would preferred start from 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.
Hi Geert - do you mean connecting an Excel file to the local Power BI desktop? If yes, I don't believe this is possible unless it's a published data model.
Great video explanation as always. For Geert’s specific question, there’s a way to do it. It’s not as smooth as the solution explained in the video, but we can connect separately and discuss how to share the process.
I think is published data model and for someone to be able to do that you need power bi license may be your office email
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.
I am also in a simular situation. Power Query and Power Pivot are realy powerful tools now add to that Python in Excel with all its chart libraries and you aren't that far away from Power BI.
what about the other way around?
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.
This video was fantastic. When “creating a table in excel linked to power bi” is there a way to go back and make adjustments (like adding other values or measures from the power bi data source) after the table is made?
No video link in description
Which video are you looking for?
@@LeilaGharani really sorry, it was meant for other vdo, thanks for replying
I use python programming ...
Fetch from dataflow
🖐️🖐️🖐️👍
U r cute 🥰
@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.
How can I transfer the dashboard with charts to excel?