Forum Discussion
Helper VRelationships in PBI Publisher for Excel
Hi rjhale,
From this article: Connect to data in Power BI
Dataset must have measures - The dataset must have model measures defined in order for Excel to treat the measures as values in PivotTables, and to correctly analyze the data.
In your scenario, you must create a measure in Power BI desktop, then place the measure in Values of PivotTable. You can download attached pbix file and test in your environment.
By the way, without getting data from the Power BI dataset, just create a normal PowerPivot table in Excel, if no measure place in PivotTable Values, data cann't be displayed proper based on relationships as well.
Best Regards,
QiuyunYu
Helper VI realize that I didn't have my link settings correct in my previous post. Here is the image of the table I was describing in my last post:
Community SupportHi rjhale,
From this article: Connect to data in Power BI
Dataset must have measures - The dataset must have model measures defined in order for Excel to treat the measures as values in PivotTables, and to correctly analyze the data.
In your scenario, you must create a measure in Power BI desktop, then place the measure in Values of PivotTable. You can download attached pbix file and test in your environment.
By the way, without getting data from the Power BI dataset, just create a normal PowerPivot table in Excel, if no measure place in PivotTable Values, data cann't be displayed proper based on relationships as well.
Best Regards,
QiuyunYu
- rjhale
That works much better once I added the measure to the table. Thanks for the help.