Solved

Is there any information on when/if the Cdata connector for Microsoft Dataverse will be available in timextender

Hi all, When deploying our tabular model/endpoint (Azure Analysis Services), we get a strange error: "This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row". In the error message we don't see which table or row this relates to and we don't know if this error relates to a datawarehouse table or a repository table. All our datawarehouse tables in this tabular model contain data and 'look good'. In addition, this error occurs in one of our environments and not in the other environments. Has anyone experience with this error? Any thought on how we can debug this one? Thanks.

I’ve some tables in my data source without primary key, but I’ve a MODIFIEDDATETIME field for all the records, that it can be used to incremental load, but TX doesn’t allow it. Some workaround?

We using multiple semantic layers, and adding more in the future. All semantic layers will probably need a calendar dimension and some other dimensions are also shared between layers. Is there any 10x method to copying between semantic layers, as it seems quite ineffective to setup: sort by summarize by category n-times on the same table

What it’s the recomended setup in the new version to support multiple developers and multiple projects? How many ODX instances, MDW instances must we would use?

TX: 6143.1 I have a TimeXtender SQL Data Source version 17.0.0.0 that I am trying to upgrade to 17.0.0.1. When I do Manage Data Sources in the ODX Server from the TimeXtender application it tells me there is an update available. When I apply this it tells me to ‘Edit the datasource’ to update the connection string. There does not seem to be an obvious way to do this. The User Portal also does not seem to have a way to update this. What is the process I should apply?

I have a SQL Server Database that I have access to using my credentials, but need to set it up using a service account (AD Account). I have tested that this account has access to the SQL Server using the provided username/password in Power BI Desktop. Here are some screenshot of what I’m experiencing.Changed Authentication to AD Password Authentication: Changed the Encrypt connection option: It seems like the username is not transfered to the server… We are using TX 20.10.38.64 TIA

Hi, We are trying to connect to a REST api and are using the JSON CData provider version 22.0.8257.0.We are connecting to two seperate datasources: Companies within Europe; Companies outside of Europe The problem with the second datasource is that the decimal seperator is mixed up.We tried some of the culture settings but it doesn’t seem to work.What is the best way to solve this?

Hello, Current Setup: TimeXtender 20.10.31.64 and ODX 20.10.31. I need help setting up incremental load on a rather different type of data flow from the standard one, that has table inserts and views inbetween tables. The flow is as follows: Table A (has incremental load today) => View1 => TableB => Table C(MDW) once directly but also through View2. Both views are necessary so we cannot remove them. My question is how to setup incremental load in timextender on this solution, if it is even possible. I am not sure how to do it through a view. Currently there is only an incremental load set up on Table A and then we fully load table B and C. Thank you

Hi, I am using the ODX server to get data from the SQL server database. After executing the transfer task, I am getting the below error. Any idea how to solve this? “System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.”

Hi, I previously obtained my TimeXtender Solutions Architect certificate. How can I get the badge to show up in the community? Kind regards, Andrew

Hi Support, We are using an ADO Data Source connection to load data in the ODX into Azure. From there we map the ODX table to the next layer in TimeXtender. This seemed to work. But now we changed the source table with added and removed columns. We sync and transfer it in the ODX and when we use preview in the ODX we are seeing the new table as expected. But when we map it in TimeXtender again to the next layer, the changes are not added. It instead maps to what is used to be. It mappes fields to columns that no longer exist, and it does not map the new added columns. We tried clearing the files in Azure to start fresh but it still mappes to the older version that no longer exist. Why would it still mapp to the old table that no longer exist in the source and no longer exist in Azure? Why would it not mapp to the new table thats in Azure now? Is there some metadata in TimeXender that first has to be cleaned before changes can be mapped? Kind regards, Tamim

After attempting to add a new column to my history table, I cannot get the table deployed and executed anymore. The new column is currently not in the table, but I also can't get it to get back to "old" historical table back without the new column. Currently have tried the following things, but so far without result: Set the project version back to an earlier version where the change wasn’t made yet; Upgrarde the PROD SQL DB Size and deploy again. It does not get beyond the Valid Table structure when deploying the historical table. When previewing I also get the following error messages: The table you are trying to preview has not been deployed yet. Deploy first. Invalid column name 'SCD Type I Hash Key'. The table you are trying to preview has not been deployed yet. Deploy first. Invalid column name 'SCD Type I Hash Key'. Details: SQL Server: 'c5d03ed4f0ca.tr30953.westeurope1-a.worker.database.windows.net,11052'SQL Procedure: ''SQL Line Number: 1SQL Error Number: 207 Invalid column na

We are planning to use Export to Azure Data Lake feature in D365 F&O My question it’s: How can connect to the Data Lake from TX? Or, we can connect to Synapse Analytics? How can we make the data source setup in TX?

I have the following code y DSA: Select * from TableA union Select * from TableB union Select * from Table C I want to replace this code with a table

We have a SFTP source on which CSV files are stored and which can be authenticated to with a ‘public key’. When using the CData SFTP-connector in ODX Server, we are able to connect with the following settings: The most important setting here is the SSH Auth mode, where we specify that we are using PublicKey authentication. Since I am not familiar with this type of connector, I would not now how to retrieve the data from the CSV files (the only table we get from the source now is the ‘Root’ table that contains the FileNames that can be found in the folder). I would rather use the CData CSV-connector, but that leaves me with a problem when testing the connection: I cannot specify that I want to use the PublicKey authentication mode. That is, it is specified under ‘SSH Auth Mode’ but it is not possible to select under ‘Auth Scheme’: As a result, we keep getting the same error on testing the connection (see attached file). I have tried setting the Auth Scheme to ‘None’, ‘Auto’, ‘SFTP’ or ‘

Hi, We are receiving some weird error messages when executing our project, which uses Azure Data Factory to copy tables from our Data Lake storage to the Azure SQL db (ODX → DWH). The error can be found in the attachments. When inspecting the pipeline run on ADF, it seems to be missing the configured activities (see second attachment). When executing the table manually from TX, the pipeline runs succesfully. Also the pipeline seems correctly configured on ADF and the pipeline run that is created when executing the table manually shows the correct activities. Any ideas as to what might be causing this? Best regards, Kaj

I’ve three excel files in a SharePoint folder: Budget Forecast Price List What it’s the best option to get the files into a TXA DSA? Can you provide me with detailed instructions?

We are seeing a situation where the next scheduled execution of a package does not start and the event is logged that this is because the previous execution is still running. However, when we closely look at finish times for these executions, the actual finish time is on average 8 minutes before the start of the next execution. I've been told that there can be a delay of a couple of minutes between the task itself actually finishing and the moment the process that executed the task is ended as well. However, 8 minutes and sometimes even up to 13 minutes seems too long. Anybody any ideas on why this occurs and what could be done about it? We're currently running TX version 20.10.25.

Can you explain how and for what it can be used?

Can you provide some documentation about this? How can I use it? For what it must be used?

Hello all, I'm new to TimeXtender and wanted to start with the training material. However, not even 5 minutes into the material. I'm finding so many links to dead or not used pages. For example: The TimeXtender user interface is a standard Windows application with a menu bar, a toolbar and a number of tabs that contain the different objects you will be working with. For more detailed information, please see The User Interface. Points to a page not found. New to TimeXtender and want to get a Trial License? If you are NOT working with a TimeXtender partner but are interested in a trying out our data management platform you can get started with a Trial License and Sandbox Environment here. Points to a 404 page. I would really like to get started with the material, and some dead pages are ok i guess, but there are a lot in there. Could this maybe be fixed? Also could you point me to the page where i could get a trial license to get started?Thank you in advance! best regards,Michael

v20.10.36.64 Hi, I have set up a simple script action as follows to set the LAST_CHANGE_DATETIME column to the ENTRY_DATETIME value if it is NULL. Script action This works fine when selecting from the table in SSMS: SSMS results using same script action The script is set as a pre-script to the ADO.NET transfer on the execute step, but when I execute the table, the following error appears: Incorrect syntax near 'LAST_CHANGE_DATETIME'. Can I implement this simple script action as a pre-script? The idea is that I can then use a fully populated LAST_CHANGE_DATETIME column for incremental loads on my ledger table. Thanks, Richard

Hi, The current Data warehouse has tables with two different DB schema's. There are already PowerBI Dash-boards using these schema's. Now I want to use the Semantic layer to copy the data (Data Export) to a SQL serverless DB. Everything works fine but I want to override the schema name. In the Semantic layer I have not find any options to change this. Is that correct or is there a way like in the Dataware house layer to change the schema?

TX: 20.10.39 SQL Server: 2019 Endpoint settings: Windows authentication hostname matching case https connection over the default proxy I am trying to push a Qlik Sense Enterprise endpoint from TimeXtender and having trouble getting the deploy successfully running. Testing connection to Qlik Sense is successful, when I Deploy I get an error when TX tries to create a new Data Connection. I see this issue pop up sometimes in other deployments and can usually overcome by manually making a Data Connection to the MDW database and giving it the same name TX would use: MDW_SLQV . In this case, I get the same error when TX tries to modify the connection. TimeXtender does create the app (and is owner of it) and can successfully reload the app, it just doesn't insert the script. If I copy-paste the TX Qlik Script into the app it works fine. As neither TX nor Qlik actually log what is going on, I cannot see what about the connection string is causing the error.