Forum Discussion
bi_analytics
2 years agoFrequent Visitor
Power BI Dataset Experience in Excel
Hi all. I'm trying to help a colleague connect to a Power BI dataset via Excel. We used this article from Microsoft as a guide: https://learn.microsoft.com/en-us/power-bi/collaborate-share/s...
foodd
2 years agoCommunity Champion
Do you have both Pivot Table or just Pivot Table, and what is the source of the Data Set?
Martaspg
2 years agoAdvocate I
Many thanks! I only see "pivot tables" and not "inser tables" option - couldn't clarify the reason for this.
The workaround you indicated works for me, it's not the ideal solution but at least it works,