Thank you Will!! Always appreciate your support my friend!

Thank you @pawewrona9749! We are BIG fans of the KQL DB over here. Agreed, it doesn't get nearly as much love as it should!

Thank you @crax2000! Really appriceate you watching!

Bradley how did you get the max bubble in your Power BI working like that?

Hi @NicolasPappasA per Bradley, "I'm breaking building this report a bit more in my next video. For the max size I used a measure to make the most recent bubble bigger than the others. I put that measure in the size option for the ArcGIS Map. The colors were a conditional statement I did not cover, but I used the values to make the trailing dots yellow and the most current dot Red. I will try to expand on this the next time I'm putting a video together on the ISS. I'm not done, hopefully, I've got some fun stuff planned for this!"

@@Tales-from-the-Field amazing... looking forward to it...I created a measure too with a max latitude but couldn't get the way you did...sounds like I am missing the conditional statement, going to try that...Thanks again for replying to this

Hi @mathiassaint per Bradley, "Sure thing. So for this demo what I wanted to showcase was that no matter what format the data is stored in with Microsoft Fabric we can access it using any Engine we would like. So why did I use KQL DB instead of the SQL Endpoint? I could do that. However, this data set is very linear in nature and I'm using Direct Query. The KQL Engine works really good with time series data, I could create T-SQL stored procedures to accomplish something similar but KQL's query capabilities for a specific fraction of time that grows as I write more data to the database allow me to get this quickly in a way that will not deteriorate over time with volume and remains lightning fast. Could be nothing more than preference on my part, but if I were building this for custmer use that's the engine I would recommend for this workload. Thanks for the questioni!"

Hi @fazizov per Bradley, "Hello sir! If I'm correct in my understanding you have a Fabric / Power BI Tenant and the Azure Account is not associated with that through the M365 Tenant. The Azure Account that you want to Mirror must be associated witht he M365 account (not an M365 expert, but this is what I've been told). If that is the case the Mirroring should not be limited to Trial capacity, you should be able to Mirror into it. The Trial capacity is equivalent to an F64 so you should have the functionality of an F64 other than those items that have been called out as not included in the trial capacity like private endpoints and managed identity. If your Azure Account is associated with the M365 account your tenant is in please let me know, Mirroring should not be facing any other restriction."

Thank you very much for detailed explanation,I will definitely try that advice!

Hi @gopalannasundaram9989 per Bradley, "Great question, this functionality is on the road map but it is not currently in Azure SQL DB Mirroring in Microsoft Fabric. Right now there are some limitations with regards to data masking or encrypting the fields and it being brought over into Microsoft Fabric. That functionally is coming but I'm not sure how soon it will be here."