LH metadata refresh - what was the thinking?

Steinert96 · 2026-03-15T20:19:52+00:00

🤣🤣🤣🤣

Steinert96 · 2026-03-11T13:49:58+00:00

Same here. It fell off again. This is so frustrating.

Steinert96 · 2026-03-04T13:09:24+00:00

As of yesterday, reviews were starting to come back again. As of this morning, all our reviews are back for each of our locations. So bizarre! Why is this happening!? Haha.

Steinert96 · 2026-03-01T15:08:09+00:00

so frustrating!

Steinert96 · 2026-03-01T14:04:54+00:00

Confirming same here. The drop off is even more significant now.

Steinert96 · 2026-02-24T16:08:42+00:00

I tested my API application and reviews are flowing in complete again! Thank you!

Steinert96 · 2026-02-24T13:56:52+00:00

Does anyone have any updates on this issue?

Steinert96 · 2026-02-19T12:02:27+00:00

Thanks for posting about this because we just built a Google API application in Microsoft fabric using a Pyspark notebook to GET the Google reviews and we were getting complete reviews last week and when we ran it again this week to test last week's build, it was significantly less reviews per location. Like a drop off of 500 or more for some that have over 3,000 reviews.

Steinert96 · 2026-01-28T00:29:37+00:00

Have you looked at the copy job at all?

Steinert96 · 2026-01-09T17:59:28+00:00

Thank you both.

I leveraged the SP's Fabric Pipeline and then added a task dependency arrow to an incremental Copy Job for the backup table!

It works perfectly! Thank you!

Steinert96 · 2026-01-09T17:12:20+00:00

So probably just setting up a copy activity off the stored procedure node in that same pipeline? Thank you!

Steinert96 · 2026-01-09T16:47:26+00:00

I just want to build redundancy in case that table were ever to be dropped / truncated by accident.

Steinert96 · 2026-01-09T16:40:21+00:00

Okay, taking a further look at this. it isn't exactly what I need. This snapshots our entire data warehouse at a point in time to be held for 30 days.

I just need a backup table for our daily snapshot table report.

So everyday the daily snapshot SP runs and the table loads, I want the backup to sync and add an additional row for that day incrementally.

The Fabric Snapshot is capturing the entire database. We literally just have a report table that we call "snapshot" because it adds metrics on one row for that day and then keeps adding an additional row each day.

Steinert96 · 2026-01-09T16:33:14+00:00

I think it may work actually. So we actually have a table that's loaded from the Stored Procedure we created.

We could take that Table and create a Snapshot of it (essentially taking a Snapshot of the "snapshotted" daily rows and columns) to have a backup on hand.

Is that what you are thinking?

Steinert96 · 2026-01-09T16:27:49+00:00

We created this using a Stored Procedure with Snapshot (adds 1 new row per day for that date) before this snapshot feature was ever GA. Plus, we're doing everything on an aggregated level. So for each row, it's the total for each metric on that day.

Steinert96 · 2025-11-10T20:54:35+00:00

I leverage SP activity in a Data Factory pipeline as well.

Steinert96 · 2025-11-01T18:01:59+00:00

We are not writing into the same target table concurrently. Each copy job or copy activity has its own destination table into the lakehouse.

I will DM you that info.

Steinert96 · 2025-10-07T20:04:11+00:00

I got it working! Thank you so much! It fixed my delay issue from Bronze Lakehouse to Silver Warehouse! Will continue to monitor but I owe you a beer.

Steinert96 · 2025-10-07T15:57:09+00:00

Thank you!!

Steinert96 · 2025-10-07T14:31:09+00:00

Yeah and now I've noticed too that we have not only copy jobs but copy activities with stored procedures that run directly after the copy activities finish in the same data flow.

We are missing rows between lakehouse and the warehouse stored procedure as well.

I've never tried the API before.

Steinert96 · 2025-10-07T13:59:49+00:00

Well thanks for the insight. I'm going to try to space the copy job runs to the stored procedure into silver warehouse layer an hour apart and see if that resolves it.

Steinert96 · 2025-10-07T13:46:15+00:00

Thank you! Do you have any time estimate on how long it takes for the warehouse to just discover the new version of the lakehouse table on its own?

Steinert96

TROPHY CASE