Recently active
The TimeXtender REST Data Source has the ability to add an API endpoint with table flattening in multiple ways: either adding the endpoint once with multple tables or adding the same endpoint multiple times. I've done some tests to find out which is fastest. The test was done on an API with an unstructured JSON data source, with root nodes on multiple levels where the XSLT Table Builder can iterate over. This means I needed to add 4 flattened tables on the same endpoint, each with different root nodes. Version numbers were REST provider version 9.0, TDI 6935.1, with Ingest running on and Azure VM and storage on ADLS Gen 2. Two ways of setting up the same endpoint with four tables My hypothisis was that 1x endpoint with 4x tables would be quicker than 4x endpoints with easch 1x table, because TimeXtender would call the API once and the multiple XSLT tansformations can happen on the same result data, rather than the API being called multiple times which would add unnecessary tansfer of d
Released in TimeXtender Data Integration 6024.1 This article describes how to deploy and execute the Deliver instance to the Power BI Premium XMLA Read/Write Endpoint. Configure Power BI Add Power BI Premium Deliver Instance Endpoint Deploying the endpoint in TimeXtender Data Integration Configure the Power BI Data Source Credential (Optional) Authenticate using a Service Principal Create an App Registration in Azure Allow service principals to use Power BI APIs Give your App Registration Admin Access Update Credentials in Deliver instance Configure Power BI Login to app.powerbi.com Select the workspace where the Deliver instance will be deployed to: Go to Workspace Settings Click the Premium tab Select the Premium per user or Premium per capcity License mode (this requires a Premium license) Copy the workspace connection. Go to the admin portal Under, Premium Per User / Dataset workload settings, Set XMLA to "Read Write". Note: If you are using Fabric Capacity to host your endpoint, t
3 likes
1 like
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
