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
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 🙈
@@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 :)
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 🙃
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.
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.
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?!
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.
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.
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
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
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?
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
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.
It seems you can edit the underlying DAX query by going to "Data" -> "Queries & Connection" -> right click on your table source -> "Properties" -> "Definition" tab -> "Command text:" box
Hi. Very usefull information, Thanks! I have a question: Is it possible to edit an existing table or pivot table to add a field from the power BI report? So if I forgot to add the saleperson to the Excel, do I need to do all the report again? Tanks again
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.
Thanks for the video, I'm getting error in the value section as "The Field you are moving cannot be placed in that area of report" for the Amount column. Can you let me know how this can be solved.
how do i edit the columns or filters of a linked table? I can't find the option to do that anywhere else than in the connection properties. Would be nice to do that in the same interface when creating the table in excel...
Excellent video, thanks Leila. But this does not work in my case. I want to export underlying data from a power bi report link from third party (our client) shared with us. Right now I can only download (export) the underlying data manually fromthe visual. Is there a way to download the underlying data automatically using power query? Please kindly advise.
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.
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
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
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?
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.
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
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?
@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 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.
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?
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?
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.
Hey Leila, I have purchased the FAST TRACK TO POWER BI. I have received an email to access the course but when I click on the link to access on Safari browser getting an error as "This site can’t provide a secure connection". Could you please help me resolve this error. I need to urgently see the course as need to complete the work. Thank You.
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
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.
@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
Hello Leila❤
9:18
Just wanted to know that, can i import the Dashboard (all the visuals and slicers) in the excel!?
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 video is a life savior, as my boss seems be data blind to anything other than Excel spreadsheets 🙃
Thanks a lot!
Our pleasure!
Thanks, this has all the PBI-excel related information I was looking for 👍❤
Thank You., You are the best teacher, i learned lot from watching your channel video.
Wow this is awesome have been seeing this export but never knew it works magic thank you
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 🙈
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
Microsoft-Excel más vivo que nunca !!!!
👍👍
Another great video!
What a delightful video! 😃🎉
Thank you! 😃
woww this is what i need. i really thank youuuu 🎉🎉
You're welcome 😊
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 🙃
Excellent content Leila.
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.
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.
Thank you for teaching
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?!
Super cool Leila, I didn't know about this, thanks!
Excellent information, Thanks, Superb you are
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
Which version can apply insert table, as my verson only pivot option
Same limitation here. My Excel just create a dynamic table... so struggling
Which color theme are you using? I really loved that.
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.
Thank you for this
Thank you ma'am 😊
Thanks a lot
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!
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?
Thank you, GREAT 👌
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
Same
That is amazing!!! Thank you 🎉
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.
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
Awesome..thank you
Superb thanks
Most welcome 😊
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.
I have the same issue
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
Have to look into this. Was disappointed to find I couldn't just grab a query from Power BI in Excel.
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.
Is there anyway for me to add or remove the fields after I Insert the table?
It seems you can edit the underlying DAX query by going to "Data" -> "Queries & Connection" -> right click on your table source -> "Properties" -> "Definition" tab -> "Command text:" box
What version of Office and or Power BI does an organization need to be able to use this function?
Hi. Very usefull information, Thanks! I have a question: Is it possible to edit an existing table or pivot table to add a field from the power BI report? So if I forgot to add the saleperson to the Excel, do I need to do all the report again? Tanks again
Can I add another measure in the same table after created it?
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.
Thanks Leila. Is there a way to remove the brackets from the table linked to Power BI?
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.
Thanks for the video, I'm getting error in the value section as "The Field you are moving cannot be placed in that area of report" for the Amount column. Can you let me know how this can be solved.
how do i edit the columns or filters of a linked table? I can't find the option to do that anywhere else than in the connection properties. Would be nice to do that in the same interface when creating the table in excel...
How do you modify the table to add additional columns?
I dont have the power bi option when i got to Get Data > Power Platform
Same issue here
Excellent video, thanks Leila. But this does not work in my case. I want to export underlying data from a power bi report link from third party (our client) shared with us. Right now I can only download (export) the underlying data manually fromthe visual. Is there a way to download the underlying data automatically using power query? Please kindly advise.
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.
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 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 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 ?
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!!!
Is it possible to modify the applied filters from PBI in our excel file?
How can you rename the columns in the table?
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
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
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.
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
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
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.
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?
what about the other way around?
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
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?
How can I transfer the dashboard with charts to excel?
@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?
So it is not possible to Export that Dashboard design to excel?
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.
Hi Leila! Excel has depreciated the get data from Power BI. Do you have an alternative solution?
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.
Do yoi use Microsoft Lists? I can't find a video about it im your channel? If not what other app you use insted?
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?
No video link in description
Which video are you looking for?
@@LeilaGharani really sorry, it was meant for other vdo, thanks for replying
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? 😢
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?
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.
Hey Leila,
I have purchased the FAST TRACK TO POWER BI. I have received an email to access the course but when I click on the link to access on Safari browser getting an error as "This site can’t provide a secure connection". Could you please help me resolve this error. I need to urgently see the course as need to complete the work. Thank You.
Sorry about the inconvenience. Please reach out to info@xelplus.com and someone from my team will help you out.
When updating the data in Excel I am always asked for the account, in your Video not, why?
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
From power plate form > from power bi is nt available in excel 2019
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
I'm on 356 and my excel doesn't have Power BI inside the power platform list !
So I can't do this with the free license, right? 😢
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
when the next video about pivot tables and python?
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 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.
I need the get data based on the date range I put in Cell range. how can we do that??