In case anyone stumbles upon this video a few year later, this method is working for me! If you follow the tutorial exactly, it should work. Thank you so much for this, such a huge help!!!!
Was struggling a lot in developing a real-time dashboard with an ODBC connection for PostgreSQL since the PostgreSQL database connection was somehow not working in my system. Fortunately, I came across your video and now my reports are all set :) Thank you so much for this video, big like!!!
Great video, really helpful. A question on this, with datasets that update continuously with fair amounts of data, will the caching cause performance issues the higher up the numbers you go?
You can, but you're still limited to 8 refreshes per day. The method in this video creates the real-time environment so the refresh limit is irrelevant. Thanks for watching!
Well done! This is a great tip and a very useful one! I will go on this example as soon as I can. I will love to do it by myself. I can not stop thinking about how many situations can be used directly or as a complement step for another project. Thanks a lot for sharing it!
@@BIElite I project work on the content of this video this weekend. I'll see if I can reproduce what you have accomplished in this video. I will love to get it done by myself.
oooh. Now i get why my page resfresh setting is not working. But it still sound silly. If my report is connected to a SQL DB then every time i set a slicer or switch page the data will refresh. So what is that page refresh setting without a play axis stands for?
Imported data is simply imported into the Power BI file whenever you click the refresh button. You can't achieve a real-time functionality unless you use the live connection or DirectQuery (as in this video)
Hi Parker....Thanks for the much needed trick we've been waiting for quite some time. Please confirm if this trick still works if we have PBI desktop client closed.
Thanks for the tip. This helped me. However, I am trying to replicate a weather station visuals - wind compass, tide chart, etc... any ideas on how to do a Compass with an arrow through the middle in PowerBI?
Hi, great tutorial.. is this still working when published to service? I am using an Azure SQL DB, and if i manually refresh it works, but not scheduled just like the desktop. Best regards
Hi, I love your Channel, do you know if this data refresh solution works if you are getting data from API, I did not see page refresh option when getting data from API
Hi very nice video but i used another method by JSON code and it is not easy so i need help if there is simple way to select specific tables from WORLD BANK website and exepole it by PowerBI and it should be up to date data ?
Can you show how to take in Date Slicer values and pass it in a Stored Procedure using Direct Query. Using Power Apps or anything of that sort. Really need something where I can send data to a stored procedure using a Date Slicer. P.S: The values coming from a slicer could be in a separate excel file.
Thanks Parker for the great tip. when the user enters the report (in the browser) the play visual is STOPED and does not play - so it's not refreshing automatically. someone needs to press on the play button... Correct me if am wrong? Thanks
Hi Parker. I strictly followed your video and it worked on the desktop. But when I publish it on Power BI service, it just didn't work. Do you have any idea why? Thanks in advance.
Great workaround!, The report in the desktop version works perfectly, however when I publish the dashboard to the online version I'm not able to see any visual in the online version. Do you have any idea why this is happening?
Thanks Nuno! I really hope they don’t lol. Especially since the Play Axis slicer has been around so long that it’s probably in a bunch of people’s reports.
@@BIElite Do you know how to update the slicer selections by the play axis? Example existing my slicers have 2 dates, but I have inserted another record with new dates, but the slicers remain old date selections. Please advise. Appreciate it.
Hi, my dataset type is streaming. For that reason i can't create new tables in the pbi desktop. I can only create measures. Do you know an alternative way to create the generateseries field using measures?
In case anyone stumbles upon this video a few year later, this method is working for me! If you follow the tutorial exactly, it should work. Thank you so much for this, such a huge help!!!!
One of the best workaround I have ever seen... BIG LIKE!
Was struggling a lot in developing a real-time dashboard with an ODBC connection for PostgreSQL since the PostgreSQL database connection was somehow not working in my system. Fortunately, I came across your video and now my reports are all set :) Thank you so much for this video, big like!!!
Do you have to edit the data model? It's not working for me unfortunately
Parker this is an amazing find. Kudos for saving me so much time in developing a solution!
Glad to hear! I really love this trick as well
Subscribed because of your work-around. 🥰
Great video, really helpful. A question on this, with datasets that update continuously with fair amounts of data, will the caching cause performance issues the higher up the numbers you go?
Great video. Question - can’t you trigger a refresh on submission from powerapps?
You can, but you're still limited to 8 refreshes per day. The method in this video creates the real-time environment so the refresh limit is irrelevant. Thanks for watching!
To clarify I’m referring to refreshing your direct queries using powerapps. I don’t think this is included in the 8 times a day limit.
is it possible to apply REAL TIME Reports but using mysql database
Well done!
This is a great tip and a very useful one!
I will go on this example as soon as I can. I will love to do it by myself.
I can not stop thinking about how many situations can be used directly or as a complement step for another project.
Thanks a lot for sharing it!
Thanks as always, Hector! I personally can’t wait to use this for future projects where DirectQuery is applicable
@@BIElite I project work on the content of this video this weekend. I'll see if I can reproduce what you have accomplished in this video.
I will love to get it done by myself.
oooh. Now i get why my page resfresh setting is not working. But it still sound silly. If my report is connected to a SQL DB then every time i set a slicer or switch page the data will refresh. So what is that page refresh setting without a play axis stands for?
Great video Parker,
Will you cover the power app in the next video?
+tejas brahmbatt I’ll see if I can come up with a good video! I’m not quite as skilled with PowerApps
@@BIElite I'm new to power bi and I'd like to know how to create an embedded power app to enter data, like the one shown in the video. Thanks!
Hi can you please explain or share me how to create a @PowerApp Create Order from and also i want import the data from one drive..
I have the free version and this isn't available. The price plans seemed to indicate that the Pro version does 8 refreshes per day...
Hello, on which type of datasource the Page refresh work? I donot seem to find this feature for my google sheet datasource. thanks
It works on any data source that allows DirectQuery. How are you connecting to Google Sheets? I only know workaround methods.
Why doesn't this work for Import data?
Imported data is simply imported into the Power BI file whenever you click the refresh button. You can't achieve a real-time functionality unless you use the live connection or DirectQuery (as in this video)
@@BIElite I thought this was doing a 'Refresh'. Apparently there are different meanings to the word 'Refresh'?
Thought the same... Is there a way to do it with an excel source?
How to install powerapp in laptp with out school email😢
Is one Play visual visual enough to refresh all reportpages? Or do I need to have a play visual on each page?
Hi Parker....Thanks for the much needed trick we've been waiting for quite some time. Please confirm if this trick still works if we have PBI desktop client closed.
This is sweet!!! Will this work with sharepoint list as the dataset?
Thanks for the tip. This helped me. However, I am trying to replicate a weather station visuals - wind compass, tide chart, etc... any ideas on how to do a Compass with an arrow through the middle in PowerBI?
Hi, great tutorial.. is this still working when published to service? I am using an Azure SQL DB, and if i manually refresh it works, but not scheduled just like the desktop. Best regards
Hi Huge, It's still working for me as of today.
Great Video,. It was very helpful. Thank you!
Great! However doesn't work in the Dashboard but in the report
Wow this is an amazing tip.
Been trying to achieve this for ages.
Thanks so much for sharing.
My pleasure, Muhammad. Thanks for watching!
Will this work for getting data from salesforce ?
This will work with any data source that supports DirectQuery.
Hi, I love your Channel, do you know if this data refresh solution works if you are getting data from API, I did not see page refresh option when getting data from API
Hi Andy, this only works for data sources compatible with DirectQuery. Pretty much only databases.
Could you make a video on how to create the Azure SQL table with the power app?
Hi
very nice video
but i used another method by JSON code and it is not easy
so i need help if there is simple way to select specific tables from WORLD BANK website and exepole it by PowerBI and it should be up to date data ?
Is this method still valid?
Can you show how to take in Date Slicer values and pass it in a Stored Procedure using Direct Query. Using Power Apps or anything of that sort.
Really need something where I can send data to a stored procedure using a Date Slicer.
P.S: The values coming from a slicer could be in a separate excel file.
Nice workaround
Thanks!
Currently (December 2020) I can't see the form "page refresh", does it still exist? What could I do to refresh my PBI in real time?
Regards!!!
Hey Jorge, are you using Direct Query?
@@BIElite, thank you for your time!!! I'm using an Excel and SharePoint data, which are the Direct Query? A real time only works with Direct Query?
Thanks Parker for the great tip.
when the user enters the report (in the browser) the play visual is STOPED and does not play - so it's not refreshing automatically.
someone needs to press on the play button...
Correct me if am wrong?
Thanks
Never mind I just saw that there is an autoplay for this visual. Thanks
Yes, autoplay is very important for this set up. Glad you found it
You did it again Parker. Awesome!!!! Thank you for share.
+Mauricio Yazigi haha my pleasure, Mauricio! Thanks for watching!
Nice video .........if don't any live cases
Thanks!
Very helpful and well done!!!!
Brilliant idea!
Hi Parker. I strictly followed your video and it worked on the desktop. But when I publish it on Power BI service, it just didn't work. Do you have any idea why? Thanks in advance.
How did you go about this? Didn't work for me as well
nice. you may want to do a power apps video
I’ll keep that in mind! It’s a lot of fun but I’m definitely better with power bi
Great workaround!, The report in the desktop version works perfectly, however when I publish the dashboard to the online version I'm not able to see any visual in the online version. Do you have any idea why this is happening?
That's interesting, are you logged into the same account?
@@BIElite I'm having the same problem. I working with postgres direct query connection.
Thank you so much
Amazing stuff mate! wow!
Incredible workaround! Not sure it will last long before Microsoft tries to shut this down, but nevertheless amazing job Parker :)
Thanks Nuno! I really hope they don’t lol. Especially since the Play Axis slicer has been around so long that it’s probably in a bunch of people’s reports.
Even if they did, can't you just import this visual from file and still use it?
Definitely, I guess as long as you have the pbiviz stored locally, you will always be able to do this. Good point
Thank you!!
No problem!
@@BIElite Do you know how to update the slicer selections by the play axis? Example existing my slicers have 2 dates, but I have inserted another record with new dates, but the slicers remain old date selections. Please advise. Appreciate it.
November update. Play axis no longer fires a data refresh.
I sure hope not.
Fantastic video!
Thank you Mau!
Simply Brilliant!
This is great!
Epic! Thank you for sharing
Thanks for watching, Mark!
great feature!
Thanks for watching Ramesh!
I cannot thank you enough!
Very useful!
Thanks Jakub!
Awesome vedio 👍👍👍
Thanks Sahar!
Brilliant!
Shucks man you saved my ass ❤️
Hi, my dataset type is streaming. For that reason i can't create new tables in the pbi desktop. I can only create measures. Do you know an alternative way to create the generateseries field using measures?