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:
- 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.
- 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.
- 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.
- 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.
