# Latest **URL:** https://community.dataddo.com/latest.md [Latest](https://community.dataddo.com/latest.md) · [Categories](https://community.dataddo.com/categories.md) · [Tags](https://community.dataddo.com/tags.md) --- ## [Welcome to Dataddo! 👋](https://community.dataddo.com/t/welcome-to-dataddo/5)
**Author:** [@system](https://community.dataddo.com/u/system)\ **Replies:** 0\ **Last updated:** [October 21, 2024, 8:35am UTC](https://community.dataddo.com/t/welcome-to-dataddo/5 "2024-10-21T08:35:58Z")
We are so glad you joined us. Dataddo A friendly place to chat and learn about Dataddo from each other. Tips and tricks, best practices, feature requests… Here are some things you can do to get started: … --- ## [Can't switch from Replace to Append](https://community.dataddo.com/t/cant-switch-from-replace-to-append/75)
**Author:** [@PHData](https://community.dataddo.com/u/PHData)\ **Replies:** 0\ **Last updated:** [May 6, 2026, 6:45pm UTC](https://community.dataddo.com/t/cant-switch-from-replace-to-append/75 "2026-05-06T18:45:19Z")
Hi, I’ve been trying to switch from Replace to Append for a data source. It saves with no errors but when I edit again it’s still on Replace. Going crazy. Refreshed cache, emptied cookies. No luck… Have you seen this i… --- ## [Issues with GA4 data or integration?](https://community.dataddo.com/t/issues-with-ga4-data-or-integration/71)
**Author:** [@JDiaz](https://community.dataddo.com/u/JDiaz)\ **Replies:** 1\ **Last updated:** [July 14, 2025, 2:37pm UTC](https://community.dataddo.com/t/issues-with-ga4-data-or-integration/71 "2025-07-14T14:37:50Z")
Hello, Has anyone experienced issues when working with GA4 data or setting up GA4 integrations? Something just doesn’t seem to be working as expected, even though the setup appears to be correct. I’m wondering if other… --- ## [Instagram flow showing zero values for impressions and views?](https://community.dataddo.com/t/instagram-flow-showing-zero-values-for-impressions-and-views/70)
**Author:** [@JDiaz](https://community.dataddo.com/u/JDiaz)\ **Replies:** 1\ **Last updated:** [July 14, 2025, 12:51pm UTC](https://community.dataddo.com/t/instagram-flow-showing-zero-values-for-impressions-and-views/70 "2025-07-14T12:51:31Z")
Hey all, Lately, I’ve been noticing something strange with Instagram flows, a few of them are returning zero values for key metrics like impressions, video views, and plays. This has been happening to me across both bus… --- ## [Authentication Error When Writing to Blob Storage](https://community.dataddo.com/t/authentication-error-when-writing-to-blob-storage/69)
**Author:** [@JDiaz](https://community.dataddo.com/u/JDiaz)\ **Replies:** 1\ **Last updated:** [June 24, 2025, 12:34pm UTC](https://community.dataddo.com/t/authentication-error-when-writing-to-blob-storage/69 "2025-06-24T12:34:56Z")
Hello, I encountered a 403 authentication error when trying to write data to a Blob Storage destination. The issue seems to be related to the authorization header or the validity window in the SAS token. The token setu… --- ## [Trouble with Google Sheets Flow](https://community.dataddo.com/t/trouble-with-google-sheets-flow/66)
**Author:** [@veronika\_volke](https://community.dataddo.com/u/veronika_volke)\ **Replies:** 1\ **Last updated:** [June 18, 2025, 3:29pm UTC](https://community.dataddo.com/t/trouble-with-google-sheets-flow/66 "2025-06-18T15:29:53Z")
Hello! One of our clients is experiencing a broken flow into a Google Sheets destination. Based on the error message, it seems the issue may be related to exceeding the 10 million cell limit in Google Sheets. Could you… --- ## [Google Sheets source not detected after authorizer and sharing](https://community.dataddo.com/t/google-sheets-source-not-detected-after-authorizer-and-sharing/67)
**Author:** [@JDiaz](https://community.dataddo.com/u/JDiaz)\ **Replies:** 1\ **Last updated:** [June 18, 2025, 9:50am UTC](https://community.dataddo.com/t/google-sheets-source-not-detected-after-authorizer-and-sharing/67 "2025-06-18T09:50:20Z")
Hello, I’ve run into an issue while setting up a data source from Google Sheets in Dataddo. The document is properly shared with the connected Google account, and the authorizer has been updated successfully. However, … --- ## [Updating Sources](https://community.dataddo.com/t/updating-sources/60)
**Author:** [@WaltBurge](https://community.dataddo.com/u/WaltBurge)\ **Replies:** 2\ **Last updated:** [May 6, 2025, 6:19pm UTC](https://community.dataddo.com/t/updating-sources/60 "2025-05-06T18:19:41Z")
We have several Sources extracting data from Snowflake, and they were initially setup with userid/password authentication. We’ve now setup a new Authorizer to use Key Pair authentication, and we need to update our Source… --- ## [Deprecation of Certain Metrics in Instagram Datasets via Facebook Graph V2 Connector](https://community.dataddo.com/t/deprecation-of-certain-metrics-in-instagram-datasets-via-facebook-graph-v2-connector/58)
**Author:** [@anashathif](https://community.dataddo.com/u/anashathif)\ **Replies:** 0\ **Last updated:** [April 22, 2025, 5:24pm UTC](https://community.dataddo.com/t/deprecation-of-certain-metrics-in-instagram-datasets-via-facebook-graph-v2-connector/58 "2025-04-22T17:24:41Z")
As of 21st April 2025, the following fields have been deprecated: Impressions metric from the Instagram Accounts Insights API (reference, here) and the Impressions, plays, clips\_replays\_count and ig\_reels\_aggregated\_all… --- ## [Pay stubs and PTO fields from Gusto](https://community.dataddo.com/t/pay-stubs-and-pto-fields-from-gusto/54)
**Author:** [@juraj](https://community.dataddo.com/u/juraj)\ **Replies:** 2\ **Last updated:** [April 4, 2025, 11:54am UTC](https://community.dataddo.com/t/pay-stubs-and-pto-fields-from-gusto/54 "2025-04-04T11:54:36Z")
Reposting a question from a user: Hi, I’m not able to access all relevant Gusto data including pay stubs and full PTO fields. --- ## [\# TikTok Organic - Metrics Showing 0 Values](https://community.dataddo.com/t/tiktok-organic-metrics-showing-0-values/57)
**Author:** [@Josep.V](https://community.dataddo.com/u/Josep.V)\ **Replies:** 0\ **Last updated:** [March 24, 2025, 3:37pm UTC](https://community.dataddo.com/t/tiktok-organic-metrics-showing-0-values/57 "2025-03-24T15:37:30Z")
Problem: Metrics extracted from TikTok Organic may show 0 values, with only the Followers Count appearing correctly. Cause: TikTok Organic API Processing Delay TikTok Organic’s API requires 24 to 48 hours to finalize… --- ## [\# "Resource cannot be found" Error (Snapchat case)](https://community.dataddo.com/t/resource-cannot-be-found-error-snapchat-case/56)
**Author:** [@Josep.V](https://community.dataddo.com/u/Josep.V)\ **Replies:** 0\ **Last updated:** [March 18, 2025, 2:34pm UTC](https://community.dataddo.com/t/resource-cannot-be-found-error-snapchat-case/56 "2025-03-18T14:34:25Z")
Problem: Source Boke and can not be rebooted or cloned. Error Message: “Resource cannot be found” Possible Causes: Incorrect or Expired Authorizer: The connected authorizer may not have the required scopes and perm… --- ## [Looker Studio " Community Connector Error " – Troubleshooting & Solutions"](https://community.dataddo.com/t/looker-studio-community-connector-error-troubleshooting-solutions/55)
**Author:** [@Josep.V](https://community.dataddo.com/u/Josep.V)\ **Replies:** 0\ **Last updated:** [March 18, 2025, 1:18pm UTC](https://community.dataddo.com/t/looker-studio-community-connector-error-troubleshooting-solutions/55 "2025-03-18T13:18:07Z")
Explanation: If you are trying to connect your source to Looker Studio, the ability to visualize data correctly may depend on the volume of data you want to display. If you encounter the “COMMUNITY CONNECTOR ERROR” th… --- ## [Filtering Advertisers in Google Ads Connector](https://community.dataddo.com/t/filtering-advertisers-in-google-ads-connector/52)
**Author:** [@TamtaGudushauri](https://community.dataddo.com/u/TamtaGudushauri)\ **Replies:** 0\ **Last updated:** [February 19, 2025, 3:01pm UTC](https://community.dataddo.com/t/filtering-advertisers-in-google-ads-connector/52 "2025-02-19T15:01:03Z")
When working with the Google Ads connector, you may need to filter out certain advertisers from your dataset. This can be done easily using SQL WHERE conditions. Filtering a Single Advertiser If you want to exclude a s… --- ## [Metric Deprecation: How to Identify and Fix Affected Sources](https://community.dataddo.com/t/metric-deprecation-how-to-identify-and-fix-affected-sources/43)
**Author:** [@Josep.V](https://community.dataddo.com/u/Josep.V)\ **Replies:** 0\ **Last updated:** [January 17, 2025, 4:09pm UTC](https://community.dataddo.com/t/metric-deprecation-how-to-identify-and-fix-affected-sources/43 "2025-01-17T16:09:17Z")
Sometimes, third-party API documentation, such as Facebook, LinkedIn, etc., does not clearly or promptly reflect metric deprecation schedules. To detect this issue faster and receive a prompt solution, I’ll share a recen… --- ## [Fix GA4 Error Message: Future currency exchange rate not exist](https://community.dataddo.com/t/fix-ga4-error-message-future-currency-exchange-rate-not-exist/33)
**Author:** [@charles\_smoak](https://community.dataddo.com/u/charles_smoak)\ **Replies:** 0\ **Last updated:** [December 19, 2024, 1:30pm UTC](https://community.dataddo.com/t/fix-ga4-error-message-future-currency-exchange-rate-not-exist/33 "2024-12-19T13:30:50Z")
Is your GA4 source breaking during its schedule but is functional when you use the manual data load button? Are you using currency metrics and do you exchange currencies? This is due to the date range expressions, such … --- ## [Wrong data format](https://community.dataddo.com/t/wrong-data-format/31)
**Author:** [@Josep.V](https://community.dataddo.com/u/Josep.V)\ **Replies:** 0\ **Last updated:** [December 6, 2024, 3:41pm UTC](https://community.dataddo.com/t/wrong-data-format/31 "2024-12-06T15:41:15Z")
WRONG DATA FORMAT Explanation If you’ve created a custom source successfully, but the extracted data shows an unexpected format (e.g., incorrect date display), it’s likely due to a mismatch in the data type. For instan… --- ## [Facebook Ads data in Dataddo does not match FB Ads Manager](https://community.dataddo.com/t/facebook-ads-data-in-dataddo-does-not-match-fb-ads-manager/30)
**Author:** [@charles\_smoak](https://community.dataddo.com/u/charles_smoak)\ **Replies:** 0\ **Last updated:** [December 2, 2024, 9:59am UTC](https://community.dataddo.com/t/facebook-ads-data-in-dataddo-does-not-match-fb-ads-manager/30 "2024-12-02T09:59:53Z")
Many customers complain that when they query FB Ads data in Dataddo their data does not match, generally with action conversions and impressions. There are 3 key things to double-check with your Dataddo source to ensure … --- ## [How Dataddo Account Owners Can Access Client Service Accounts (e.g., Facebook Ads, Google Ads) for Data Extraction](https://community.dataddo.com/t/how-dataddo-account-owners-can-access-client-service-accounts-e-g-facebook-ads-google-ads-for-data-extraction/29)
**Author:** [@anashathif](https://community.dataddo.com/u/anashathif)\ **Replies:** 0\ **Last updated:** [November 27, 2024, 7:43pm UTC](https://community.dataddo.com/t/how-dataddo-account-owners-can-access-client-service-accounts-e-g-facebook-ads-google-ads-for-data-extraction/29 "2024-11-27T19:43:13Z")
Issue: When a Dataddo account owner wants to access their clients’ accounts in Facebook Ads (or similar services), they have two options: Solution: If the owner’s Facebook Business Manager account manages the client… --- ## [OneDrive as a source - How to access the files?](https://community.dataddo.com/t/onedrive-as-a-source-how-to-access-the-files/28)
**Author:** [@anashathif](https://community.dataddo.com/u/anashathif)\ **Replies:** 0\ **Last updated:** [November 27, 2024, 7:34pm UTC](https://community.dataddo.com/t/onedrive-as-a-source-how-to-access-the-files/28 "2024-11-27T19:34:44Z")
Issue: Sometimes in the OneDrive as a source, clients face difficulty in defining the path of the file that they would like to use. This guideline will help you to overcome this issue. Solution: The path would be the … --- ## [Displaying Incorrect Results in Google Ads](https://community.dataddo.com/t/displaying-incorrect-results-in-google-ads/27)
**Author:** [@TamtaGudushauri](https://community.dataddo.com/u/TamtaGudushauri)\ **Replies:** 0\ **Last updated:** [November 25, 2024, 3:11pm UTC](https://community.dataddo.com/t/displaying-incorrect-results-in-google-ads/27 "2024-11-25T15:11:39Z")
Problem: The data appears to match overall, but the issue arises with the data type and the decimal point formatting in the reported values. Specifically, the field ‘cost\_micros’ in the source system is being exported as… --- ## [SERVER\_ERROR ( caused by source wrong type)](https://community.dataddo.com/t/server-error-caused-by-source-wrong-type/26)
**Author:** [@Josep.V](https://community.dataddo.com/u/Josep.V)\ **Replies:** 0\ **Last updated:** [November 21, 2024, 1:19pm UTC](https://community.dataddo.com/t/server-error-caused-by-source-wrong-type/26 "2024-11-21T13:19:32Z")
Explanation: SERVER\_ERROR is a generic error indicating a connection issue between Dataddo and the server. If there is no further specific information about the cause of the error, it’s recommended to verify that the sou… --- ## [Instagram (IG) and Facebook (FB) Showing the Same Values](https://community.dataddo.com/t/instagram-ig-and-facebook-fb-showing-the-same-values/25)
**Author:** [@Josep.V](https://community.dataddo.com/u/Josep.V)\ **Replies:** 0\ **Last updated:** [November 18, 2024, 2:56pm UTC](https://community.dataddo.com/t/instagram-ig-and-facebook-fb-showing-the-same-values/25 "2024-11-18T14:56:52Z")
You might encounter a situation where the extracted data for both your Facebook (FB) and Instagram (IG) sources show identical values. This occurs because both platforms share the same data extraction endpoint, which is … --- ## [Troubleshooting Sub-Accounts for Facebook/Instagram & Twitter Facebook Business Tools Settings](https://community.dataddo.com/t/troubleshooting-sub-accounts-for-facebook-instagram-twitter-facebook-business-tools-settings/23)
**Author:** [@Undilashvili](https://community.dataddo.com/u/Undilashvili)\ **Replies:** 0\ **Last updated:** [November 12, 2024, 2:36pm UTC](https://community.dataddo.com/t/troubleshooting-sub-accounts-for-facebook-instagram-twitter-facebook-business-tools-settings/23 "2024-11-12T14:36:08Z")
Sometimes, Facebook can cause issues that may disrupt your account’s functionality or prevent sub-accounts from being detected in your Facebook/Instagram connectors. If you can’t find the connected sub-accounts, follow t… --- ## [UNEXPECTED VALUE ERROR (INTEGER, FLOAT) // “: expected integer value](https://community.dataddo.com/t/unexpected-value-error-integer-float-expected-integer-value/20)
**Author:** [@istvan](https://community.dataddo.com/u/istvan)\ **Replies:** 0\ **Last updated:** [November 11, 2024, 3:59pm UTC](https://community.dataddo.com/t/unexpected-value-error-integer-float-expected-integer-value/20 "2024-11-11T15:59:57Z")
UNEXPECTED VALUE ERROR (INTEGER, FLOAT) “: expected integer value, but unexpected value ‘1.333334’ given” Explanation: This error occurs when a field in the source is set to an incorrect data type. In the example above… --- ## [Unique Reach metric in Looker studio](https://community.dataddo.com/t/unique-reach-metric-in-looker-studio/19)
**Author:** [@istvan](https://community.dataddo.com/u/istvan)\ **Replies:** 0\ **Last updated:** [November 11, 2024, 3:51pm UTC](https://community.dataddo.com/t/unique-reach-metric-in-looker-studio/19 "2024-11-11T15:51:40Z")
The reach metric is a unique metric. Unfortunately, unique metrics are not able to be summed up in the dash boarding applications such as looker studio in this case. In case, the Reach metric is really important, then we… --- ## [Question about flows](https://community.dataddo.com/t/question-about-flows/16)
**Author:** [@juraj](https://community.dataddo.com/u/juraj)\ **Replies:** 0\ **Last updated:** [November 4, 2024, 3:39pm UTC](https://community.dataddo.com/t/question-about-flows/16 "2024-11-04T15:39:03Z")
This is a frequent question we get through chat: “If I have 3 FB accounts and I fetch data from each them using the FB connector to big query, does that count as 3 data flows?”