Recently active topics

I'm using dynamic values function in the TX REST connector 9.1.0.0. I use id's from another endpoint to loop through in my second endpoint path. This works well when I use “From Endpoint Table” but now I want to add a filter to only get the id's with a flag “hasresponse=true”.I've read the page but I still get an error with my Endpoint query. “No such table” the error message says. I've tried several things like adding a schema. But all with the same response. Is there something wrong with my syntax?Error: 

Need help with TimeXtender data transformation issue. We're pulling sales data from SQL Server but getting errors during the transform step. The source has decimal values but TimeXtender seems to be reading them as text.Also need to set up a simple incremental load based on ModifiedDate field. Should be 2-3 hours remote work to fix the data types and configure the incremental logic.Need working by Tuesday for our weekly data refresh.Please Contact Me Asap.

I am having issues with decimal numbers in my Power BI model created with TimeXtender XMLA endpoint (version 7026.1).No matter the precision of my datatype on SQL server it seems like all values are forced into a rounded 4 decimal size. Is there a setting hiding somewhere to prevent this behavior?Below are examples or test data to demonstrate the behavior.Inspecting the model with tabular editor it seems all decimal fields are stored as fixed decimal rather than the expected double Test data Result in Power BI 

I have an issue, and i have not been able to identify if this is a TX issue or a DWH issue.This is how TX is set up:I have a MS PowerApp that writes to the APP database.I can see that the records are in the DWH, like in the table below.  I have confirmed that the entetried are in APP-stack.At 07:30 in the morning, execution package runs, then this happens:Meaning, the DW_ID that were previously Bob’s and Marlen’s are now overwritten by Kim and Tom.There are no traced of DW_ID 101 and 103 being registrered by Bob and Marlen either in ODX or in DSA.I dont know if it happens before the execution job runs, during or after. I have been scratching my head for the past couple of weeks.

I have two tables with no unique identifer. There a two posts that mentions NEWID() as a way to create a unique identifier, so it seems that it can be used:How to add a default value to a unique identifier field – TimeXtender SupportHow to Add a Default Value to a Unique Identifier Field in TimeXtender Classic | CommunityI have created a filed in each of my table and made it Primary Key.My question is:What happens if we Deoply and Execute on DSA table with a column that creats uniqe id with NEWID()? Does it create new IDs that are different, or does the table keep the IDs generated before? 

We are using the provider Azure Data Factory - SQL Server for a lof connections where the instances for these connections contains almost the same data but each time another customer. What we have noticed when the incremental load is setup to look at a datetime field called DW_MODIFIED_date. it will never load that 1 record which is in the table. When I exclude that table from the incremental load then I have 1 record loaded.When I include the table again in the incremental load it is removing the first folder from the previous load and don’t write a new file because it was not updated.When I remove the folder from the container and I incremental load that client table again I get no record at al while it should be the first load. Even if the incremental load is on and there is no file  then I expect to have in the initial load the data.

I’m using TimeXtender REST Data Source v10.2.0.0 with two endpoints: A static endpoint that returns a list of IDs. A dynamic endpoint that retrieves additional data for those IDs. The problem is that not all IDs from the first endpoint exist in the second. When the dynamic endpoint tries a ‘non-existent ID’, the API returns a 500 server error, stopping the data transfer.This is an external API, so I have no control over it. From what I can see, the datasource provider doesn’t offer error handling (like try/catch or “skip if failed”).I could create a curated list of valid IDs, but there are thousands of IDs that can change at any time, making this impractical. I could also ask the API provider to return empty JSONs instead of errors, but I’d prefer to handle it on my side.Any advice?

What it’s the reason to this message:It would very useful to be able to do it.

Hello,Is it possible to Extract data from an existing Lakehouse into a Prepare instance without needing to move it into the TimeXtender Ingest instance? The use case is to avoid replicating the data again, if the customer has already ingested data into a data lake or Lakehouse.Thanks in advanceTim

Hi, I’m trying to connect to a API using Timextender REST version 7.1.0.0 but my result is only one row of data. In Postman I get much more data. It might be because the API returns JSONL and TX tries to handle it as JSON. I’m trying to convert it to Text but it still doesn’t work.  Earlier I managed to complete the goal in Power Query even with pagination.  Now I’ve hit a brick wall and I need your help to proceed. My result in ODX:  My result in Postman:Here’s my connection profile:{  "Name": "MixPanel",  "Description": "",  "Provider": {    "TemplateId": "d4aa4001-fd7b-4c65-b76d-f9710d551c1e",    "DisplayName": "TimeXtender REST",    "ProviderVersion": "7.1.0.0",    "X64BitVersion": true,    "ProviderType": 6  },  "RestProperties": {    "Pills": [      {        "Name": "Authentication",        "Description": "Configure authentication settings to securely access the API using tokens, keys, or other credentials.",        "Id": "rest-general-authentication",        "IsSelected": true 

Deliver Instances represent the culmination of all the extraction, transformation, and loading that happens prior to the tables being added to the Deliver model.Security allows developers to implement role based access to a Deliver Instance endpoint, providing access to either the entire data set, or a subset of the data that is related to specific field values.Model-level Security is configured by creating a role that is not associated to any Row-Level Security Setup, and then associating that role to an endpoint. This association will grant full access to the endpoint for all the members of that role.Row-level Security (RLS) filters the data that is available in the endpoint using a set of one or more field values that are configured in a Row-Level Scurity Setup and then associating these field values with either Role members or a user’s logon credentials. As such, different users may have access to different data when accessing the same endpoint. Row-Level Security is configured acc

I’m planning to change a history table in DSA into an incremental table without removing the history and I want to make sure that I understand some of the settings correctly. The ideal outcome for me is the following:New data added incrementally without the history being maintained Regarding the old history: I want to keep all rows with [SCD Is Current]=1 I don’t want to keep rows with [SCD Is Current]=0 Here are some questions I have about options in Table Settings > Data extraction :Does it make sense for this scenario to have the boxes checked for “Truncate raw table before transfer” and “Empty raw table after data cleansing”? What is the best approach for me to take with the delete options (“Don’t handle deletes”, “Use soft deletes” and “Use hard deletes”)? If I’m fine with new rows being overwritten can I then create some kind of incremental rule to make sure that old history is changed (or at least not for [SCD Is Current]=1)?Thanks,Árni

Semantic models represent the culmination of all the extraction, transformation, and loading that happens prior to the tables being added to the Semantic layer.Security allows developers to implement role based access to a Semantic endpoint, providing access to either the entire data set, or a subset of the data that is related to specific field values.Model-level Security is configured by creating a role that is not associated to any Row-Level Security Setup, and then associating that role to an endpoint. This association will grant full access to the endpoint for all the members of that role.Row-level Security (RLS) filters the data that is available in the endpoint using a set of one or more field values that are configured in a Row-Level Scurity Setup and then associating these field values with either Role members or a user’s logon credentials. As such, different users may have access to different data when accessing the same endpoint. Row-Level Security is configured according to

We are suddenly having issues with opening last saved project in TimeXtender. The error says:An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.Location: Table: SelectionRuleFieldsForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist in the parent table..We have tried to go back to the project that we saved before the lastest one. We are able to open that it not able to save it. The errror says:An error occurred while saving the project to the database.An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.Location: Table: SelectionRuleFieldsForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist in the

We are unable to open our instance as we are prompted with the following error message: TX Version 7047.1 

Hi,I got this structure(see below) from my rest api and I need to add order_id into each line of order_line. How can I flatten out order_lines with the order_id? I have tryed different  ways, but when I have two order lines only one get the right order_id value…. Order/Orderlinesbest regards,Bjørn A.

Hi there! We have had a small problem recently whereas Table A is on the staging/DSA layer and contains the following columns: Column 1 (PK)Column 2 (PK)Column 3Column 4 … etcNow this table has three sources - three Business Central instances. In two of the sources the original order of columns is Column 1, Column 2 but in the third source the order is Column 2, Column 1.We get the following error when incremental load is enabled:  "TIMEXTENDER COPY DATA LOOP", "Failure happened on 'Sink' side, Column 2 contains an invalid value. We have been able to manage this error previously by ordering the columns in the same way as in the source.However, now the sources have different orders of the columns and therefore not possible to use that way to get around this. Any ideas or suggestions? 

SYMPTOMSA data source that is using the TimeXtender REST API Data Provider fails with the following error message.System Exception: Failed to execute request for endpoint ‘<Endpoint Name>’One or more errors occurred.A task was cancelled.System.AggregateException: One of more errors occurred → System.Threading.Tasks.TaskCancelledException: A task was cancelled. Additionally, a review of the log files may indicate that pagination is working and that a number of pages are successfully loaded for the endpoint that is referenced in the error, but eventually the loading operation gets stuck on a particular page and after retrying the load for that page three times the “A task is cancelled” exception is thrown.CauseA likely cause of this error is that the timeout period for loading the data has been exceeded. There may be other edge cases, but this is the most likely cause.ResolutionThere are two ways to help mitigate the problem of exceeding the timeout period.Reducing the page size In

Today, we’ve released an updated XML/JSON data source provider.XML/JSONVersion: 23.10.0.0 (TDI) / 1.4.2 (20.10 BU) / 16.4.11.0 (20.10 ODX)Added logging of file names. Added support for handling multiple metadata URIs. Added trimming of long column names. Changed pattern matching for files to be case insensitive. Fixed issue with same table names being used in different schemas. Fixed issue with metadata URI handling for Sharepoint locations.

Hello, TimeXtender 20.10.67 with ODX. We have a source (azure datalake) that will geta json file dumped with the following format table.name/”date-when-file-dumped”. The files will be15million + rows and dumped atleast once a week.What I want to achieve is for the connector to only extract the latest file and have it dynamically change. I can’t figure out a way to effectively do this in the connector, as the uri connection string wants to point to a specific filename or take everything in a concat.I can’t figure out a way to change the URI dynamically and the only option I can think of in theory is concatenating all the json in the connector, including resourcecolumns and doing a custom query table on the connector with a DSR rule based on the MAX filedate.However, in a year or two when there will be 50+ files (750 million rows in theory with concat), I am not sure how the performance or scalability of that solution will be. Anyone have done something similar or have a better idea how

Hi all,Since about a week ago, we’re seeing random but frequent (almost daily) failures in ODX extract tasks from two sources: TimeXtender SQL Data Source (version 22.0.2.1) (SQL database) – runs from 05:00 to ~05:45 (45 min) UTC. Error: Cannot access a closed Stream (HttpRequestException). TimeXtender SQL Data Source (version 22.0.2.1) (Synapse Severless SQL pool)  – runs from 05:00 to ~05:00:30 (30 sec) UTC. Error: System.TimeoutException: The operation has timed out. Manual retries later in the morning succeed without issue.The Synapse serverless SQL pool is pre-triggered ~15 minutes in advance to avoid cold start, and both the ODX environment and the data sources have generous timeout settings.We use Azure Data Lake Gen2 storage as our ODX storage.Any idea what might be causing these recent failures?Thanks,sva

Good day,I am afraid I have lost the MFA on my phone and I can no longer login in the TimeXtender App.Is it possible to have this reset?  Kind regards,René

As your project gets larger and more data, transformations, and lookups are added, it is natural for deployment and execution times to increase.The Performance Recommendations Tool can be used to leverage a set of performance improving features that are available in the TimeXtender Classic Desktop. The Performance Recommendations Tool will analyze your project and recommend changes that may improve your project's performance. After running its analysis, the tool will present you with a menu of recommendations that you can then select to apply or not. These recommendations include the following:Merge all conditional lookups in a table: Sets the Merge conditional lookupsoption on tables to Merge all if possible (fastest). This can improve performance on tables with many conditional lookups with 20% or more. Use lookup operator None with joins other than Equal: Changes Operator option on lookup fields to None if the join on the lookup field does not use the Equal operator. This can improv

As projects grow, the increasing complexity can make it hard to keep track of all objects and their dependencies. To help you with this, TimeXtender contains four visualization features:Data lineage  Impact Analysis  Relation Diagram  Data FlowThe relation diagram is only available on tables, while the other types can be used on most objects in TimeXtender.The purpose of data lineage is to show how objects gets their data, while the impact analysis feature clarifies how data is used. The relation diagram displays the relations that have been established to and from the table in question.Data Lineage Customizing the Display Impact Analysis Relation Diagram Data FlowData LineageRight click on an object, click Visualizations and the select the desired type of visualization.  Selecting Data Lineage from the Visualization menu will provide a diagram similar to the following that traces the objects and their mapping from the beginning to the end of the project. Customizing the DisplayThe vi