Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am working with Opportunity table from Microsoft Dynamics D365.
In the application, the field Status can have any of those values:
When I am using D365 as a data source in Power BI, I am accessing a different layer of the database, where the field Status is named "StateCode", and the values are:
My goal is to have in Power BI the values that are visible in the application.
Questions:
Thank you!
Thomas.
Solved! Go to Solution.
Hi @Anonymous,
Create one dimension table based on unique records from all related table columns and build relationships obviously will affect performance.
If you can direct modify source data, it should more quickly than my suggestion.
If you mean do replace operation on power query side, it should complex and low performance.(you need to create a dictionary table to compare and replace state on all of tables who contains state column)
Regards,
Xiaoxin Sheng
HI @Anonymous,
I'd like to suggest you create a status table with state code and description, build relationships from this table to all of statuscode columns.
After this step, you can use 'description' column to replace status code column on visualization to display more clearly status description.
Regards,
XIaoxin Sheng
Hi @v-shex-msft
Thanks a lot for your reply.
That is a good idea, but I'm worried about performance, and I'm wondering if replacing the values directly in the table would make calculations faster ?
What do you think ?
Thank you.
Thomas.
Hi @Anonymous,
Create one dimension table based on unique records from all related table columns and build relationships obviously will affect performance.
If you can direct modify source data, it should more quickly than my suggestion.
If you mean do replace operation on power query side, it should complex and low performance.(you need to create a dictionary table to compare and replace state on all of tables who contains state column)
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |