🚀 Calling all data enthusiasts! 💼🌟 👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off! 🔗 Grab your discounted spot here: learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d 💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼 🔗 Explore the possibilities here: learn.pavanlalwani.com/courses/Power-BI-Dax-634fa813e4b0c08ed56c9919
Hi Pawan Sir , you are a gem of knowledge when comes to tool technology. I have watched almost all your playlists. I have a request to you please make a seperate playlist for dax . I am sure that playlist would be more viewed on the youtube with respect to learning videos. big thanks to you.
Hello, When I try to create a data source credentials it is greyed out. I couldn't solve this issue. By the way in the "gateway connection" section status shows "Not configured correctly". In the "actions" section asking add to gateway and when I choose it asking windows username and password. Entered and I received this: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance." Is there any way to solve it?
I uploaded a REPORT in the BI services which has MAP. In BI services noted that the MAP didnt get updated and showed a msg - "Map and Filled map visuals are'nt enabled for your org. Contact Tenant admin....." after following the links i noted this msg "Purchase Premium capacity.... " but we are already a PRO. The same issue came in desktop also, after enabling , the MAP appeared properly. Can you pl clear me what might be the probelm. Also is PRO license is not sufficient or we need to hv the premium version ?
Hi Pavan, if a user has setup gateway and automatic refresh in a report, can I being a Co owner of the report will be able to see the data gateway details?
Hi Sumit, Start Power BI Desktop by opening the connection file you downloaded. Put your authentication information into Power BI Desktop. Token of Personal Access: Please enter your Azure Databricks or Azure Active Directory personal access token. Windows Azure Active Directory: After selecting Sign in, adhere to the prompts on the screen. Thanks.
@@PavanLalwani Thanks Pavan. But if I understand it right, is not it the method to connect to Power BI desktop? Actually I was talking abt Power BI Service. Once the dashboard is published from PBI Desktop to PBI Service, in order to setup data connection from databricks to PBI Service, do I have to setup gateway in PBI Service?
Hi. Thanks for the tutorial and it worked for me except data source placed on Microsoft Teams. I used authentication with my organizational credentials and it started working. I need a little more help. i nee to change report often (keeping same data set but different visualization parameters) depending on requirements of manager for next meeting presentation so is there any method to reflect changes made on Power BI Desktop report to report on Power BI Services with refresh or publishing report is the only solution? Thanks in advance.
very nicely explained... there is not even a single topic which I didn't understand... there are some topics I have some doubts, How to contact you??? or if you can upload the more videos for more topics... Awaiting reply :)
Your explanation is awesome👏✊👍 thanks and i have a question that when I have the category and the rate of risk like good, bad etc in treemap visual while drill down I want to change colors and when I drill up it should hv default colors and when I select one particular category it shows good, bad etc this should show me color change for each category selected... But I'm not able to change pls help with dax at the earliest
Thanks for the video. My dataset is not refreshing because of "InvalidConnectionCredentials" error when I use my windows authentication and tick the Skip test connection. I am confident that my windows user and password are entered correctly but not sure why my data source is not refreshing. When I untick the Skip test connection it does not save the new changes. What should I do?
Hi sir, we are using OData feed, we need to schedule refresh without gate way that is the client requirement...can you please tel me the procedure how to schedule refresh in power bi service without gateway when we using OData feed . we get data from two urls.
While refreshing data, I want to keep last and past data and add another raw for additional data. I am sure it is possible. But I don't know-how may be you can help.
Thank you for this wonderful video. Is there a way to automatically refresh and publish power bi reports on services where data is not present in services?
Hi Sir, One Serious Problem This video shows 9 videos in Section 10 but there is only 8 Videos Video No. 10.9 is missing Create Report Directly in Power BI Service is missing...
I have a doubt i.e if I have one report, from Monday - Friday I want to refresh at 3 am and Saturday & Sunday I want to refresh at 5 am. How to do this? Can you please help me to achieve this.
Dear, One query i have on persomal datagateway.. We neee to keep always online the personal gateway.. I mean to say.. Before refresh data we need to login gateway everytime.. How we can keep online always
@@PavanLalwani Thanks a lot... One info... How to install power bi excel publisher in office 365.... Actually i try but not getting any option , plz help me out ..
Hello sir, I have enabled the schedule refresh for my schematic model but still the data is not updating it is asking for refresh in power bi service. Seeking your guidance…
Hi Pavan, just observed when you added "NorthEast" and "SouthWest" in Region column the Donut Chart didn't show 6 sections; however, it was showing in Matrix, why so? plz revert.
@@PavanLalwani If I have say, Pavan Sir is a masterpiece, a gem, a reformer, nobody can doubt about it. Sir, a lot of respect for you... we love you Sir
Hi sir you videos are pretty much simpler and easier but can you make a video of live project or any real time issues or real time project type What I mean to say is like a complete report and video form raw data to publish
Pavan Bhai, kitna smooth se bola aapne.......... Sabkuch direct dimagh mein :D Appreciate your time & effort in sharing this knowledge to us. You got a +1 subscriber now :)
Hi Pavan, Thanks again for your great Video. I want to create more reports in Power BI. If possible could you please let me know where I can get dataset and problem statement to create. Thanks in advance :)
Hi Sir Thank you for sharing this, I've an urgent doubt if you can help.. I've created 2 measures , want to create new measure which says measure1^measure 2 but it's not happening in my able visual.. can you please help?
Hello Sir thank you for the video, i need one help. I am using link server technique in my power report fetching data from SQL server and on SSMS ibm7 db2 link server is configured. I need to add refresh method in service my concern is which sever i need to add as data source it's for SQL or IBM7 dB2
I did it but it is still showing error, My data is in Server Shared Location like \\server1\shared\BI, Is this asking Excel file password or Server shared location access password ?
Sir, It's very helpful video, I need to calculate net profit by analyzing & connecting 4 different sheets on weekly basis , there I also need to apply DAX so that I can aquire "Net Profit" , please guide me to do this work to refresh my profit report automaitcally Thank You
no no - trick is how would you refresh the page automatically otherwise user has to always click the refresh icon all the time.Please show us the embed refresh option for this.
I always refer your videos for any kind of doubts. Thanks a lot. I am facing an issue that "my report refresh is getting failed several times due to time out. How do I increase the timeout period. It helps me a lot. The Error message is, DataSource.Error: Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. DataSourceKind = SQL. DataSourcePath = Server & DB name . Message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. ErrorCode = -2146232060. Number = -2. Class = 11. . The exception was raised by the IDbCommand interface. Table: v2AssetStatus.
🚀 Calling all data enthusiasts! 💼🌟
👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!
🔗 Grab your discounted spot here: learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d
💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼
🔗 Explore the possibilities here: learn.pavanlalwani.com/courses/Power-BI-Dax-634fa813e4b0c08ed56c9919
Tremendous Flow of the Narration sequence.................Really appreciate your work,Great Tutorial.
Start watching from 9:10 shoud do the work.
Great Teacher😊
thank you sir for the tutorials
Great Video, been stuck on this for ages!! thanks so much for your help
This is a good video in that you showed errors too, with their solutions.
I have subscribed your channel, you are legend in terms of technical knowledge.
Nice and clear explanation. Thanks
Thanks sir for providing such wonderful videos
Hi Pawan Sir ,
you are a gem of knowledge when comes to tool technology. I have watched almost all your playlists.
I have a request to you please make a seperate playlist for dax . I am sure that playlist would be more viewed on the youtube with respect to learning videos.
big thanks to you.
Thank you for the video. Saved my life!
Amazing , I’ve got promoted 😂🤝🤩
Thank u so much for this video... it has been a saviour.
Very useful, clear and easy explanation. Thanks a lot.
Thank you,
Please subscribe the channel for more videos!
As usual! Simple and Best!! Thank You so much sir.
I concern if scheduled refresh can run at 3 AM if my computer is turn-off at that time ?
Best explanation of this I have seen, thank you sir
Thanks Pawan!
This is very Helpful
Hi Pavan,
very Helpful thanks lot..
Very crisp and clear content. Thanks
Hello, When I try to create a data source credentials it is greyed out. I couldn't solve this issue. By the way in the "gateway connection" section status shows "Not configured correctly". In the "actions" section asking add to gateway and when I choose it asking windows username and password. Entered and I received this: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance." Is there any way to solve it?
SIR, I will refer my friends to your channel.
THANKYOU SO MUCH , YOUR VIDEO REALLY HELPED IN OFFICE .
Thank you sir, this was very helpful.
Hi Joaquin,
You are welcome !!
thank you , good explaination
Hello Sir, I am using the share point list for that do I need to install power bi gateway?
This is such a great help - thank you! :)
very informative video, Thanks alot.
Keep it up
great stuff, thanks
Hi MB
You are welcome !!
Very helpful as I'm the admin in charge of this 😂 Thank you for making this video!
I uploaded a REPORT in the BI services which has MAP. In BI services noted that the MAP didnt get updated and showed a msg - "Map and Filled map visuals are'nt enabled for your org. Contact Tenant admin....." after following the links i noted this msg "Purchase Premium capacity.... " but we are already a PRO.
The same issue came in desktop also, after enabling , the MAP appeared properly.
Can you pl clear me what might be the probelm. Also is PRO license is not sufficient or we need to hv the premium version ?
Hi Pavan, if a user has setup gateway and automatic refresh in a report, can I being a Co owner of the report will be able to see the data gateway details?
Hi, do you know how to do it already? Cause I facing similar question and I manage to see you comment here.
Hi turns out co owner would also need gateway on their end
excellent thank you...
what if the data source is at some cloud location (ADLS or databricks)? will I have to use gateway?
Hi Sumit,
Start Power BI Desktop by opening the connection file you downloaded. Put your authentication information into Power BI Desktop. Token of Personal Access: Please enter your Azure Databricks or Azure Active Directory personal access token. Windows Azure Active Directory: After selecting Sign in, adhere to the prompts on the screen.
Thanks.
@@PavanLalwani Thanks Pavan. But if I understand it right, is not it the method to connect to Power BI desktop? Actually I was talking abt Power BI Service. Once the dashboard is published from PBI Desktop to PBI Service, in order to setup data connection from databricks to PBI Service, do I have to setup gateway in PBI Service?
Thanks. Can you do direct mode report in power bi server. Every time getways are not working direct mode with SQL dataset
Amazing sir
thanks man, figuring this out on my own would have been a nightmare and probably ended with me giving up
Hi Bashar,
You are welcome !!
Great 👌 Thanks a lot Pavan.
Welcome
The gateway has to be installed on the machine where the source lies?
Hi. Thanks for the tutorial and it worked for me except data source placed on Microsoft Teams. I used authentication with my organizational credentials and it started working.
I need a little more help. i nee to change report often (keeping same data set but different visualization parameters) depending on requirements of manager for next meeting presentation so is there any method to reflect changes made on Power BI Desktop report to report on Power BI Services with refresh or publishing report is the only solution?
Thanks in advance.
Can we schedule report for two different timing on two different days???
Thank you..amazing video explained very well
You are the best thank you so much!
Pls Post Joints concept in powerbi it will be helpful, thanks
Ty very much!!! very helpful) is it possible to refresh reports (not dataset) without clicking Refresh button in visual?
Thank you 👍
Thank you 👍🏼👍🏼👍🏼
very nicely explained... there is not even a single topic which I didn't understand... there are some topics I have some doubts, How to contact you??? or if you can upload the more videos for more topics...
Awaiting reply :)
I wish I could like this 100 times. I have never had such a clear explanation of setting a gateway and scheduling refreshes
Hi Charity G
Thank you so much !!
Your explanation is awesome👏✊👍 thanks and i have a question that when I have the category and the rate of risk like good, bad etc in treemap visual while drill down I want to change colors and when I drill up it should hv default colors and when I select one particular category it shows good, bad etc this should show me color change for each category selected... But I'm not able to change pls help with dax at the earliest
Thanks for the video. My dataset is not refreshing because of "InvalidConnectionCredentials" error when I use my windows authentication and tick the Skip test connection. I am confident that my windows user and password are entered correctly but not sure why my data source is not refreshing. When I untick the Skip test connection it does not save the new changes. What should I do?
Hi sir, we are using OData feed,
we need to schedule refresh without gate way that is the client requirement...can you please tel me the procedure how to schedule refresh in power bi service without gateway when we using OData feed .
we get data from two urls.
Awesome
thanks a lot for explaining
While refreshing data, I want to keep last and past data and add another raw for additional data. I am sure it is possible. But I don't know-how may be you can help.
Keep watching videos, your answers are waiting in next 4 sections
@@PavanLalwani Is the expected autosave video released?
Thanks
Thank you for this wonderful video. Is there a way to automatically refresh and publish power bi reports on services where data is not present in services?
Hi Sir,
One Serious Problem This video shows 9 videos in Section 10 but there is only 8 Videos Video No. 10.9 is missing Create Report Directly in Power BI Service is missing...
I have a doubt i.e if I have one report, from Monday - Friday I want to refresh at 3 am and Saturday & Sunday I want to refresh at 5 am. How to do this? Can you please help me to achieve this.
I have prepared a report using direct query. Now i have to publish the report in live....plz say some idea
No words 😶👍
Dear,
One query i have on persomal datagateway.. We neee to keep always online the personal gateway..
I mean to say..
Before refresh data we need to login gateway everytime..
How we can keep online always
A seperate server machine having gateway installed should be dedicated and it should be ON always .
@@PavanLalwani
Thanks a lot...
One info...
How to install power bi excel publisher in office 365....
Actually i try but not getting any option , plz help me out ..
Very helpful tutorials indeed for Power BI.. thanks a lot..
After refreshing the report @ 8.30 in the video, why doesn't the doughnut chart of profit by region change?
Can we refresh Page when we get data through store procedure
hello sir
I can't able able to install gateway and edit data source creddential because of personal profile, i am a student , what i should do now ?
great
Hello sir, I have enabled the schedule refresh for my schematic model but still the data is not updating it is asking for refresh in power bi service.
Seeking your guidance…
Check if gateway is working
Else check on community for already solved queries
Hi Pavan, just observed when you added "NorthEast" and "SouthWest" in Region column the Donut Chart didn't show 6 sections; however, it was showing in Matrix, why so? plz revert.
There are in six in donut but due to small amount it is not visible. To check you can add data labels
@@PavanLalwani If I have say, Pavan Sir is a masterpiece, a gem, a reformer, nobody can doubt about it. Sir, a lot of respect for you... we love you Sir
Hi can anyone help if we can do the same thing in Qlik sense also?
Very clear explanation for all the topics. Thankful to you for all your effort. Bliss :)
Hi Anita
You're most welcome !! and Thank you so much !!
Hi sir you videos are pretty much simpler and easier but can you make a video of live project or any real time issues or real time project type
What I mean to say is like a complete report and video form raw data to publish
bro...did you find any real time projects...please let me know
@@bitsdiaries unfortunately that's a too old ping and i am working now
@@raghunadhamara6243 Okay bro... congrats
What is the difference between automatic refresh in Power BI Desktop and Power BI Service?
How to do you create a new report from a published data source and work on it from the desktop?
Hi Sir,
Can Report automatically update in power bi desktop free version
Hi Raghav,
Yes, we can do it automatically updated to use automatic page refresh in Power BI Desktop
@@PavanLalwani thanks Sir
Pavan Bhai, kitna smooth se bola aapne..........
Sabkuch direct dimagh mein :D
Appreciate your time & effort in sharing this knowledge to us. You got a +1 subscriber now :)
Hi Pavan, Thanks again for your great Video. I want to create more reports in Power BI. If possible could you please let me know where I can get dataset and problem statement to create. Thanks in advance :)
Hi Sir
Thank you for sharing this, I've an urgent doubt if you can help.. I've created 2 measures , want to create new measure which says measure1^measure 2 but it's not happening in my able visual.. can you please help?
Hello Sir thank you for the video, i need one help. I am using link server technique in my power report fetching data from SQL server and on SSMS ibm7 db2 link server is configured. I need to add refresh method in service my concern is which sever i need to add as data source it's for SQL or IBM7 dB2
SQL
Why do u need a gateway for refreshes?
I did it but it is still showing error, My data is in Server Shared Location like \\server1\shared\BI,
Is this asking Excel file password or Server shared location access password ?
I have followed your steps and manage to refresh but my data is not updated. Did i miss something?
Where is 10.9 pavan garu?
Sir,
It's very helpful video,
I need to calculate net profit by analyzing & connecting 4 different sheets on weekly basis , there I also need to apply DAX so that I can aquire "Net Profit" , please guide me to do this work to refresh my profit report automaitcally
Thank You
sir, 10.9 create report directly in power bi service video missing sir, please add that video, thank you sir
You can ignore that video.
@@PavanLalwani ok sir
no no - trick is how would you refresh the page automatically otherwise user has to always click the refresh icon all the time.Please show us the embed refresh option for this.
You will get answer in next video
Baaghi ka Mol kya hai
Hello Pavan,
Thank you for your awesome videos. Video 10.9 is missing from the playlist. Request you to please add the same.
You can ignore that 10.9
10.9 missing
Very nice overview of the Gateway. Thanks so much for sharing!
Would this work if the file was a MS Access database instead of Excel?
Pro trick: watch series at Flixzone. Me and my gf have been using it for watching all kinds of movies during the lockdown.
@Louie Hudson yea, I've been watching on Flixzone for since december myself =)
@Louie Hudson yup, I have been using flixzone for years myself =)
@Louie Hudson Yea, been using Flixzone for since november myself :D
@Louie Hudson yup, I've been using flixzone for since december myself :)
Sir 1 saal main sirf 19k subscriber hue hai ... earning to ho nahi rahi hogi
I always refer your videos for any kind of doubts. Thanks a lot.
I am facing an issue that "my report refresh is getting failed several times due to time out. How do I increase the timeout period. It helps me a lot. The Error message is,
DataSource.Error: Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. DataSourceKind = SQL. DataSourcePath = Server & DB name . Message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. ErrorCode = -2146232060. Number = -2. Class = 11. . The exception was raised by the IDbCommand interface. Table: v2AssetStatus.
Excellent explanation, thank you
i love ur explaination.wow super sir
Dear Prem,
Thanks for watching! Please subscribe the channel for more videos!😀
Very useful. Tqsm.
You are welcome !!
Thank you so much