Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
powerbiexpert22
Post Partisan
Post Partisan

migrate cubes from Targit BI to Power BI

How to migrate  cubes and dimensions from Targit tool to Power BI.

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

Hi, @powerbiexpert22 

I'm happy to answer your questions. Moving the data from Targit BI to Power BI needs to pass through several stages. Below is a common data migration process:

  1. Collect information and planning: Before starting migration, you need to collect all the necessary information about data in Targit BI. This includes the type of data, structure, size, and the relationship between models. Planning the process of migration, determining the priority of migration, and creating a list of data to migrate.
  2. Data extraction: First, you need to guide multi -dimensional data sets from Targit BI, and guide multi -dimensional data sets as formats of certain standards, such as .xlsx, .csv, etc.
  3. Data conversion: Since different BI tools may use different data structures and formats, data may need to be converted to ensure that they are compatible with Power BI. Use ETL (extraction, conversion, load) tool or manual method to process data to eliminate any inconsistencies.
  4. Load data in Power BI: Use the "Get Data" function in Power Bi Desktop to load the conversion data to Power BI. According to the needs and the list configuration data model, including creation relationship, definition of measure value, etc.

 

For more details on migrating to Power BI, you can click on the link below:

https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-migration-overview

 

 

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jianpeng-msft
Community Support
Community Support

Hi, @powerbiexpert22 

I submitted a solution in the post, and I’m wondering if it was helpful to you. Could you please provide some feedback on my solution?

v-jianpeng-msft
Community Support
Community Support

Hi, @powerbiexpert22 

I'm happy to answer your questions. Moving the data from Targit BI to Power BI needs to pass through several stages. Below is a common data migration process:

  1. Collect information and planning: Before starting migration, you need to collect all the necessary information about data in Targit BI. This includes the type of data, structure, size, and the relationship between models. Planning the process of migration, determining the priority of migration, and creating a list of data to migrate.
  2. Data extraction: First, you need to guide multi -dimensional data sets from Targit BI, and guide multi -dimensional data sets as formats of certain standards, such as .xlsx, .csv, etc.
  3. Data conversion: Since different BI tools may use different data structures and formats, data may need to be converted to ensure that they are compatible with Power BI. Use ETL (extraction, conversion, load) tool or manual method to process data to eliminate any inconsistencies.
  4. Load data in Power BI: Use the "Get Data" function in Power Bi Desktop to load the conversion data to Power BI. According to the needs and the list configuration data model, including creation relationship, definition of measure value, etc.

 

For more details on migrating to Power BI, you can click on the link below:

https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-migration-overview

 

 

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.