I had to make a presentation about my Intership in a manufacturing industry where my highlight was data visualisation One of the aspects was pricing And this video helped a lot Really appreciate it👍🏼
Thanks sir for valuable information Sir, i have got to know that there has been development in quick measure wherin we just need to type sentence and calculation is done own. Can you check how do we get that and if possible can you please prepare video on same
Thank you for the clarification, it is more than wonderful, but the most important question is: When I upload my data to Power BI, is the data seen by the BI team or the Microsoft team? Or rather, where is it stored? I usually import data from Excel files from the desktop and upload it to Power BI. Is this considered dangerous? Since my company's data is shared with an external platform.
I am not sure about this. But "technically" possible for MS to look at your data (may be to resolve an issue. You should consult your company's policies before uploading files to Power BI workspace.
I am holding Pro license and using Premium workspace. Scheduled refresh configured and shared with colleagues, all are able to open the report and present…
Hi Chando, Thanks for the video. It's super useful . Right now am new to this world, and I have a free version. But I would like to share to my boss via embedding into ppt? But the share option or exporting to ppt option is not available. Is it becaz I use free version? Is there any other way I can take presentation with dynamic slides?
Hi Chandoo - This is super helpful...I am already using Power BI in my organization but a quick question for you - If I have a Premium license and share the report with others in the organization, will they be able to view the report with a free license or they will need higher license for that. I will embed live Power BI report in the PPT and share to the larger audience. Thanks again!
This depends on what PREMIUM license you have. In most cases, all the "viewers" also need a license (usually either PRO or PREMIUM). But certain onprem plans or per capacity plans allow for a number of free users. I suggest talking to your office 365 admin for a better understanding on this.
Hi bro, I'm a Power bi developer. as a power bi developer which cloud service is best for career growth pls suggest 1. Power BI with Azure data factory or 2. Power BI with Azure synapse .
Awesome video! Just a quick question, in premium per capacity license, is there some kind of user limit? Or can you give access to your analysis to as many free users as you want as long as you have the premium per capacity license?
If we make a Power BI report using the ArcGIS map, (question) Do we need to purchase the ArcGIS subscription as well in order to embed that power BI report on a website? Please reply!!!
Can we connect MySQL postgres database in power bi premium version. Like I am using desktop in that their are many options to connect the database. In my organization I want to connect MySQL and postgre database and share the dashboard with client. Client doesn't have an idea about power bi. They just want dashboard of their business.
Hi Chandoo, really nice and helpful content!!! I have a question... As a consultant, I want to deliver dashboards to external clients, Which is the best option for that and how could I connect to their data, make a report, and then refresh it with new data on their own? (sorry that was 2 questions)
You can share with external users. But they will also need a PRO license. The process seems to have changed over time. But try this. 1) open the report in app.powerbi.com 2) click on share 3) click on the three dots ... on the send link screen (click on manage permissions) 4) Use + button next to direct access and type the email address of your client. 5) They will get an email with the report link. 6) ask them follow the process and see the report (they may have to sign in to your tenant, not sure)
Hi Chandoo, I am loving your content. I have a Microsoft 365 E1 subscription and I was considering upgrading to an E3 simply because I love Excel and the E3 says it has advanced Excel analytics features like Power Query and Power Pivot. I don't know what the difference between them and the already available ones I have. Would it be of any benefit to upgrade instead to the E5 which includes Power BI pro? I am the only one using this plans, because of Excel as I said and OneDrive has 5Tb all for me.
If you just want Power BI alone, you can also directly include Power BI Pro or Premium into your existing office subscription. In most cases E3 is sufficient but again both E3 & E5 have so many other extra software and features that may never get used. Note that standalone Excel (even Excel 2016) has Power Pivot & Power Query by default (any version above student). So you don't need anything more if you just care about those two.
@@chandoo_ Thank you so much for your reply! I was able to get a Microsoft 365 E5 Developer and it includes all the same things a MS E5 do except for phone support, and best of all, free. I love your content, and I was wondering if I can buy your course in monthly payments. I could do one, but it will take me a couple of months. Keep up the good work!
Hi is there any way to share our reports/dashboards to recruiters and anyone with a link so that they can see and iteract with it without using powerbi pro or premium?
Quick question sir, In our organization we have 3 developers who will be building and publishing the reports and these reports will be shared and viewed by around 50 resources, also reports are relatively small may be around 5 MB each, I would like to know if I we should be procuring just 3 licenses for developers or 53 (do we need to buy even for just viewing the published licenses). Thank you
I am not a licensing expert, but my understanding is you need 53 pro licenses at the least. Your developers may want to have premium license if they want to do some advanced stuff. Do check with your IT admin or Microsoft liaison if you are not sure.
I am migarting from tableau to power BI. what is the equivalent of tableau public in Power BI ? If I take Power BI Pro, can i disable some security setting and make dashboard available to view outside of organization. Tableau public helps when interviewer asks show me some of your projects. But in Power BI there is nothing like that.
I just remember we have chatgpt..so below is reply from our bro chatgpt Power BI offers a variety of options for sharing content, although there isn't a direct equivalent to Tableau Public. Here are some options: 1. **Power BI Publish to Web:** This feature allows you to share a Power BI report with others on the internet. This is similar to Tableau Public. You create your report and then create a public web link that can be viewed by anyone on the internet without requiring a license. However, please note that this option does not have the same security and privacy settings as the regular Power BI service - once a report is published to the web, anyone with the link can access it. 2. **Power BI Embedded:** This is a more advanced option where you can embed Power BI reports, dashboards, and other content into an app or website. This is a more complex solution and typically requires some development skills. 3. **Power BI Apps:** Power BI apps are a way to package up a collection of dashboards and reports and publish them to users in your organization. This is not as public as Tableau Public, but can be a good way to share content with a large number of people. With regards to your second question, Power BI Pro does allow sharing reports and dashboards outside of your organization, but you need to be careful with this. You can share with external users by sending them a direct invite, but these users would also need a Power BI Pro license to view the content. However, you can disable some security settings to allow content to be viewed more publicly, such as using the "Publish to Web" option mentioned above. Be sure to review Microsoft's documentation and guidelines on this to ensure you are not inadvertently exposing sensitive data. For interview purposes, the "Publish to Web" feature is probably the best option to showcase your work similar to Tableau Public. Please remember that any data you share this way should be data that you have permission to share and is not sensitive or private.
Hi Chandoo, I'm reaching out today with a query regarding Power BI licenses. Our organization has a specific requirement where one person will be assigned either a Power BI Pro or Power BI Premium license, while all other users will be assigned Microsoft Fabric Free licenses. I am aware that only power BI pro license user can share report with other power Bi pro license holder. The key question is whether the person with a Power BI Pro or Power BI Premium license can share reports with users who have Microsoft Fabric Free licenses. I would greatly appreciate your assistance in determining which licensing arrangement would be most suitable for our company's requirements. Thank you for your help.
We are a small business with less than 35 users. What license do we need to obtain of only two individuals are creating reports but the rest of the users need to view them only ?
Hi, One question! I am working in a company (around 200 employee size) and I am the only person who has power BI pro license and when I publish and link the power BI report to share point. I want all other 199 employees who do not have power BI Pro license should just view the power BI report data. Is that possible ?
In this case, everyone in the org. needs a pro license to view what you build. You can contact the Microsoft licensing rep to see how to get this bundled with rest of your office etc. subscriptions.
They can share it for "open web" so any one in the world can see. If you want to share so that only certain users can see it, your viewers need at least PRO license.
hi chandoo.. i want to keep an admin account and then distribute reports to view ONLY for 4 users. SO can i take just once licence for admin and other 4 users can use their domain account to view the report.. or do i have to purchase 5 licences in total.. Pls guide...
Hi Chandoo. Handy video, thank you. However, I have a question. I have a PRO account as a developer of the dashboard. Two users in my hospital have Free licenses. They successfully accessed the dashboard I published on the PowerBI service workspace. A few days ago, after I publish a new version, they couldn't access it anymore. Here is the error message: 'Upgrade to Power BI Pro. To use Power BI Pro features, upgrade to a Pro license.' I have no idea about these features. I added a couple of simple visuals, and that's it. Can anyone please advise?
You do need pro / premium accounts to share and publish content. Your company might already have PRO access for everyone. Talk to IT / office 365 admin and they can figure out what to do.
From what I've seen, they don't. I have an Office 365 E1 tenant for a couple of years and never seen any Office nor Microsoft 365 subscription going on sale, they actually went up in price a few months ago.
Hello! I am a data analyst in a Bank in Bangladesh. Have to handle customer data of 2 million rows with MS Access daily. MS Access is slow and not user friendly. Recently leraning power bi from your channel.its interesting. Could I import a text file consisting 2 million rows to power bi (FREE VERSION). Pls give your feedback. As my boss said paid version is not allowed.
Hi Ustaad e Mohtaram. I am a freelancer, which option is good for me? If a client gives me a project, I prepare it on my free desktop application and send the .pbix file to my client who has the PBI license. will he be able to use that file? Please reply as I am confused by this dilemma.
@@chandoo_ could you have share how to create a paginated report. I want to create a weekly report with text ( cmt automatically) + table . It is possible ?
![Run Away - Tzuyu(TWICE) ツウィ 쯔위 [Music Bank] | KBS WORLD TV 240906](http://i.ytimg.com/vi/KnHNNyAYiu0/mqdefault.jpg)
I had to make a presentation about my Intership in a manufacturing industry where my highlight was data visualisation
One of the aspects was pricing
And this video helped a lot
Really appreciate it👍🏼
Дякую за відео!) Достатньо детально і зрозуміло вийшло. А головне - я знайшов відповідь на своє питання.
Good and to-the-point explanation Chandoo! Liked it! :-)
Thanks Vijay :)
Thanks Chandoo! I'm sticking with the Free version
Yes, for almost 4 years, I just had FREE version and only this year I signed up for Pro.
Sir, aap excel ke saath-saath Google Sheets ki bhi tips and tricks bataya Karo!! , Jo ki bahut useful ho daily life me....
Please sir!!!
Thanks sir for valuable information
Sir, i have got to know that there has been development in quick measure wherin we just need to type sentence and calculation is done own. Can you check how do we get that and if possible can you please prepare video on same
Yes, TD. This is a new feature in November version. I am working on a video explaining the same. Watch out for this (probably in Jan 2023).
@@chandoo_ thank you Sir
Thank you for the clarification, it is more than wonderful, but the most important question is: When I upload my data to Power BI, is the data seen by the BI team or the Microsoft team? Or rather, where is it stored? I usually import data from Excel files from the desktop and upload it to Power BI. Is this considered dangerous? Since my company's data is shared with an external platform.
I am not sure about this. But "technically" possible for MS to look at your data (may be to resolve an issue. You should consult your company's policies before uploading files to Power BI workspace.
i like your Editing Sound /// And thanks for the information...
I am glad you enjoy it :)
Thanks chando for information 🙂
Many many years ago; there was a poor Website.. Chandoo something :)
You are great bro :)
Which POWER BI do you have... ? Tell me comments
As a freelancer which kind of power bi is needed for client projects?
Hi brother can you please make a video on SQL stored procedure with examples.....it will help me alot ..
I am holding Pro license and using Premium workspace.
Scheduled refresh configured and shared with colleagues, all are able to open the report and present…
Hi Chando, Thanks for the video. It's super useful . Right now am new to this world, and I have a free version. But I would like to share to my boss via embedding into ppt? But the share option or exporting to ppt option is not available. Is it becaz I use free version? Is there any other way I can take presentation with dynamic slides?
hahahahaha
Dear Chando, which computer brand you use for data analyst and data science tasks ? Please mention brand with type
There is pro and premium license but none with the tag ' free' license as visible on downloads.
The "free" option simply refers to the Free Power BI Desktop software.
Hi Chandoo - This is super helpful...I am already using Power BI in my organization but a quick question for you - If I have a Premium license and share the report with others in the organization, will they be able to view the report with a free license or they will need higher license for that. I will embed live Power BI report in the PPT and share to the larger audience. Thanks again!
This depends on what PREMIUM license you have. In most cases, all the "viewers" also need a license (usually either PRO or PREMIUM). But certain onprem plans or per capacity plans allow for a number of free users. I suggest talking to your office 365 admin for a better understanding on this.
Hi bro,
I'm a Power bi developer. as a power bi developer which cloud service is best for career growth pls suggest 1. Power BI with Azure data factory or 2. Power BI with Azure synapse .
I am not really sure. I don't think you will have one BEST option. Why not familiarize with both?
Awesome video! Just a quick question, in premium per capacity license, is there some kind of user limit? Or can you give access to your analysis to as many free users as you want as long as you have the premium per capacity license?
If we make a Power BI report using the ArcGIS map, (question) Do we need to purchase the ArcGIS subscription as well in order to embed that power BI report on a website?
Please reply!!!
As freelance work, can we share reports with any of the clients using Pro ?
Finished watching
Can we connect MySQL postgres database in power bi premium version. Like I am using desktop in that their are many options to connect the database.
In my organization I want to connect MySQL and postgre database and share the dashboard with client. Client doesn't have an idea about power bi. They just want dashboard of their business.
To enable python scripts on our published dashboard on web, will Pro be sufficient or should we get premium?
Hi Chandoo, really nice and helpful content!!! I have a question... As a consultant, I want to deliver dashboards to external clients, Which is the best option for that and how could I connect to their data, make a report, and then refresh it with new data on their own? (sorry that was 2 questions)
Does Pro subscription allow to export BI report to Power point ?
Thanks!
Thanks for the super and love :)
Hi- Chandoo, I have pro license and I build report. If I want to share report to client who is not in my organization how can it be achieved.
You can share with external users. But they will also need a PRO license. The process seems to have changed over time. But try this.
1) open the report in app.powerbi.com
2) click on share
3) click on the three dots ... on the send link screen (click on manage permissions)
4) Use + button next to direct access and type the email address of your client.
5) They will get an email with the report link.
6) ask them follow the process and see the report (they may have to sign in to your tenant, not sure)
Hi Chandoo, I am loving your content. I have a Microsoft 365 E1 subscription and I was considering upgrading to an E3 simply because I love Excel and the E3 says it has advanced Excel analytics features like Power Query and Power Pivot. I don't know what the difference between them and the already available ones I have.
Would it be of any benefit to upgrade instead to the E5 which includes Power BI pro?
I am the only one using this plans, because of Excel as I said and OneDrive has 5Tb all for me.
If you just want Power BI alone, you can also directly include Power BI Pro or Premium into your existing office subscription. In most cases E3 is sufficient but again both E3 & E5 have so many other extra software and features that may never get used.
Note that standalone Excel (even Excel 2016) has Power Pivot & Power Query by default (any version above student). So you don't need anything more if you just care about those two.
@@chandoo_ Thank you so much for your reply! I was able to get a Microsoft 365 E5 Developer and it includes all the same things a MS E5 do except for phone support, and best of all, free.
I love your content, and I was wondering if I can buy your course in monthly payments. I could do one, but it will take me a couple of months. Keep up the good work!
For freelance service like dashboard creation for clients, should I purchase Pro version or can share saved file to client, please advise।।
Hi sir, can I use sql server EE without license with PowerBI premium p1 license
thanks!
Thank you so much. This video was very helpful..😊
Hi
is there any way to share our reports/dashboards to recruiters and anyone with a link so that they can see and iteract with it without using powerbi pro or premium?
Does this mean that you can't download or save any of the work you've done on the free version to create a portfolio for yourself?
Hey, create projects you can save the file. You can also export the pdf file.
Quick question sir, In our organization we have 3 developers who will be building and publishing the reports and these reports will be shared and viewed by around 50 resources, also reports are relatively small may be around 5 MB each, I would like to know if I we should be procuring just 3 licenses for developers or 53 (do we need to buy even for just viewing the published licenses). Thank you
I am not a licensing expert, but my understanding is you need 53 pro licenses at the least. Your developers may want to have premium license if they want to do some advanced stuff. Do check with your IT admin or Microsoft liaison if you are not sure.
Please tell how to login power bi because it is not taking personal email id
Sir i purached pro, but i can't publish my report, it's showing no content
Thanks for the valuable comparison.
My pleasure!
I am migarting from tableau to power BI.
what is the equivalent of tableau public in Power BI ?
If I take Power BI Pro, can i disable some security setting and make dashboard available to view outside of organization.
Tableau public helps when interviewer asks show me some of your projects. But in Power BI there is nothing like that.
I just remember we have chatgpt..so below is reply from our bro chatgpt
Power BI offers a variety of options for sharing content, although there isn't a direct equivalent to Tableau Public. Here are some options:
1. **Power BI Publish to Web:** This feature allows you to share a Power BI report with others on the internet. This is similar to Tableau Public. You create your report and then create a public web link that can be viewed by anyone on the internet without requiring a license. However, please note that this option does not have the same security and privacy settings as the regular Power BI service - once a report is published to the web, anyone with the link can access it.
2. **Power BI Embedded:** This is a more advanced option where you can embed Power BI reports, dashboards, and other content into an app or website. This is a more complex solution and typically requires some development skills.
3. **Power BI Apps:** Power BI apps are a way to package up a collection of dashboards and reports and publish them to users in your organization. This is not as public as Tableau Public, but can be a good way to share content with a large number of people.
With regards to your second question, Power BI Pro does allow sharing reports and dashboards outside of your organization, but you need to be careful with this. You can share with external users by sending them a direct invite, but these users would also need a Power BI Pro license to view the content.
However, you can disable some security settings to allow content to be viewed more publicly, such as using the "Publish to Web" option mentioned above. Be sure to review Microsoft's documentation and guidelines on this to ensure you are not inadvertently exposing sensitive data.
For interview purposes, the "Publish to Web" feature is probably the best option to showcase your work similar to Tableau Public. Please remember that any data you share this way should be data that you have permission to share and is not sensitive or private.
Yes, disabling the security / privacy option and sharing it is equivalent to Tableau Public. There are no data limits too.
Thanks. Very helpful
Chandon, thank you. Good and timely video.
You are welcome Moises.
is there a data limit in power bi pro trial account?it seems that the data I connected in BQ is incomplete with missing data
PQ only shows the preview, but all data should load when you "close & apply".
Thanks Bro for giving clear information.
Always welcome
Hi Chandoo, I'm reaching out today with a query regarding Power BI licenses. Our organization has a specific requirement where one person will be assigned either a Power BI Pro or Power BI Premium license, while all other users will be assigned Microsoft Fabric Free licenses.
I am aware that only power BI pro license user can share report with other power Bi pro license holder.
The key question is whether the person with a Power BI Pro or Power BI Premium license can share reports with users who have Microsoft Fabric Free licenses. I would greatly appreciate your assistance in determining which licensing arrangement would be most suitable for our company's requirements.
Thank you for your help.
AFAIK, you still need Pro license or more to view the reports, irrespective of what Fabric license you hold.
Thanks! Works a lot!
We are a small business with less than 35 users. What license do we need to obtain of only two individuals are creating reports but the rest of the users need to view them only ?
I think PRO license is the way to go.
thanks friend. hi from colombia
It seems we can't use app source to get custom visuals with free version. Is that right or is there a way? I tried and it asked to login first
Hi, One question!
I am working in a company (around 200 employee size) and I am the only person who has power BI pro license and when I publish and link the power BI report to share point. I want all other 199 employees who do not have power BI Pro license should just view the power BI report data. Is that possible ?
In this case, everyone in the org. needs a pro license to view what you build. You can contact the Microsoft licensing rep to see how to get this bundled with rest of your office etc. subscriptions.
Is PBI similar to Tableau for forecasting data?
They are both visualization apps interface might be different though
Can a User with PRO share / embed the Power BI report to any user with Free Only?
They can share it for "open web" so any one in the world can see. If you want to share so that only certain users can see it, your viewers need at least PRO license.
Is there way to install Power BI on Mac?
Thanks for the info. But given your content, you should have made a video on this ages ago
You are welcome.
hi chandoo..
i want to keep an admin account and then distribute reports to view ONLY for 4 users.
SO can i take just once licence for admin and other 4 users can use their domain account to view the report.. or do i have to purchase 5 licences in total.. Pls guide...
As far as I know, you need 5 licenses.
That was all I wanted to know.
I only have 365 E3 but my boss have E5. Can I make power Bi reports then my boss will edit it for her to publish?
Hi Chandoo. Handy video, thank you.
However, I have a question.
I have a PRO account as a developer of the dashboard.
Two users in my hospital have Free licenses. They successfully accessed the dashboard I published on the PowerBI service workspace.
A few days ago, after I publish a new version, they couldn't access it anymore.
Here is the error message: 'Upgrade to Power BI Pro. To use Power BI Pro features, upgrade to a Pro license.'
I have no idea about these features. I added a couple of simple visuals, and that's it.
Can anyone please advise?
You do need pro / premium accounts to share and publish content. Your company might already have PRO access for everyone. Talk to IT / office 365 admin and they can figure out what to do.
Do they provide black Friday discounts?
From what I've seen, they don't. I have an Office 365 E1 tenant for a couple of years and never seen any Office nor Microsoft 365 subscription going on sale, they actually went up in price a few months ago.
Hello! I am a data analyst in a Bank in Bangladesh. Have to handle customer data of 2 million rows with MS Access daily. MS Access is slow and not user friendly. Recently leraning power bi from your channel.its interesting. Could I import a text file consisting 2 million rows to power bi (FREE VERSION). Pls give your feedback. As my boss said paid version is not allowed.
Yes, you can
Bro is it possible to survive with excel knowledge in dubai?
Hello sir,
As a beginner I use Power BI free
😀
I make pdf from free version and share😂
How can I use power bi on MacBook for free?
Hi Ustaad e Mohtaram. I am a freelancer, which option is good for me? If a client gives me a project, I prepare it on my free desktop application and send the .pbix file to my client who has the PBI license. will he be able to use that file? Please reply as I am confused by this dilemma.
Can you please share your guidelines for other Power BI Developers who wants to start freelancing as a beginner? Where should they start? And how ?
@Just Relax Music: While this works, I suggest going for PRO at least if you want to test out the service end of things and collaborate.
@@chandoo_ advice for starting freelancing in powerbi?
Paginated reports are now available on Pro.
Yes.
@@chandoo_ could you have share how to create a paginated report. I want to create a weekly report with text ( cmt automatically) + table . It is possible ?
This is coming soon on the channel. (Possibly in late Jan 2023)
tenq
Aapka koi hindi channel bhi hai kiya?
company will provide me Bi or this bill is on me... because half of my salary will go on Bi
If they want you to work on Power BI, in most cases they will.
Not getting a job
If I purchase a Power Bi Pro license, can I share my dashboard with others without a license? @Chandoo
You saved me....CHandoo is Awsome....
Thanks very informativeeee !