Hi ​@geeky_analyst 

The core issue here is that the Ad image URLs provided by the Facebook API are temporary and expire after a few days. To address this, you need to refresh these URLs daily by querying the Facebook API.

Here’s how you can set it up:

1. Create a Table in Supermetrics:

   • Name the table something like “FA_creative_url.”
   • Include the dimensions: Ad creative ID and Ad creative image URL. (Or if you Ad creative URL are one to one relation to Ad ID, you can use Ad ID field too)
   • If the table setup requires a metric, you can include one (e.g., Impressions) but disregard it since it’s not relevant for this use case.

2. Join the Data in Power BI:

   • Use the Ad Creative ID or AD id to link the image URL with your main dataset in Power BI. (Note: Your main dataset must already have data at the Ad Creative ID / Ad ID granularity for the linking to work correctly.) This setup ensures that fresh URLs are always linked to the corresponding ad creatives.

3. Handling Date-Ranges in Supermetrics:

   • If you’re using Supermetrics Storage to Power BI, note that tables without a date dimension are treated as snapshot tables. By default, they fetch the complete history available from the API.
   • If you’re using the Supermetrics to Power BI connector, specify the time range (e.g., the last six months). This will retrieve fresh URLs for any posts that have had activity within that period. However, older posts will not receive updated URLs.
   • To preserve historical ad images, you’ll need to implement a mechanism to save the images to your own storage. Unfortunately, Supermetrics doesn’t currently offer a built-in solution for this.

In short, while it takes a little effort to manage, this setup ensures your ad creatives show up properly in Power BI without constant hiccups. Hope this clears things up!

Here is screenshot in Power BI about linking tables. 
I do recommend using a star schema for Power BI data model.