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

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.

Reply
Anonymous
Not applicable

Service content pack - source data

Hello,

 

Few questions wrt PBI Service content pack (Financial Performance ervice content pack) - 

 

1. Is the data available in Service content pack a dummy one or is the data fetched from the Dynamics365 from my Organisation ?

2. How do I perform calculations/transformations on this data set since we can only connect to Service content pack from PowerBI service?

3. How do I identify the calculated measures/columns within the dataset available in Service content pack?

4. When I connect to my Dynamics365 of my Organisation, I do not see some of the metrics/KPI columns available with the dataset in Service content pack (Ex. For Financial Performance service content pack, metrics like Actual, Budget,EBIT etc.)

 

 

Thanks,

Ajay

1 ACCEPTED SOLUTION
ashishrj
Power Participant
Power Participant

@Anonymous Data is not dummy one and is fetched from your organization Dynamics365. Since you are connecting it via Power BI online, you cannot perform any sort of calculations/transformations on this data when online. All of your queries mentioned in points 2,3,4 could be possible when connecting it from Power BI Desktop tool. Hope this helps !

View solution in original post

1 REPLY 1
ashishrj
Power Participant
Power Participant

@Anonymous Data is not dummy one and is fetched from your organization Dynamics365. Since you are connecting it via Power BI online, you cannot perform any sort of calculations/transformations on this data when online. All of your queries mentioned in points 2,3,4 could be possible when connecting it from Power BI Desktop tool. Hope this helps !

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors