Link to the Excel File: docs.google.com/spreadsheets/d/1tTRfVz-g99um2MUN31U-QQuUCj4dwL4v/edit?usp=share_link&ouid=110287700425339553017&rtpof=true&sd=true
Thank you very much, both videos that you have published in real time are spectacular. How do you share this? It seems to me that it cannot be shared in a public link, with the real time effect. It seems to me that you can't in an Iframe either The only way to share it is with the source file? How can I present it that is on a screen in a room? Could you share reading mode? Sorry for so many questions, what I need is to share that real time with people who can't edit the dashboard or the data Thank you so much
If your database is online, you can share the file with anyone which will be updated in real time just as shown in the example. You can share file with any number of people and everyone's file will get updated in real time (if your server allows that much traffic). Second option is power bi server, but that is not going to allow real time updation.
There is no xlsx file. The data is randomly generated in Python and stored in SQL Server Database, from where it is directly connected to the Power BI Desktop Application using Direct Query. XLSX does not support realtime connection.
You can also generate random data using SQL only, we have those videos as well. If you dont want to use python, you can only use SQL query to do the same.
@@virtual_school Hi! I was successful in generating random data. However, after loading data to PBI, the 'location' and all others had no data. I noticed from the video a 'call center live monitoring simulation.xlsx file. How was that generated?
Thank you so much for the reply and for this wonderful project. I did it using SQL server only but could you please guide the same for MYSQL also, How to connect MYSQL in direct Query Mode
