Forum Discussion

bi_analytics's avatar
bi_analytics
Frequent Visitor
3 years ago

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...
Need Help
foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
3 years ago

Do you have both Pivot Table or just Pivot Table, and what is the source of the Data Set?

 

  • bi_analytics's avatar
    bi_analytics
    Frequent Visitor
    3 years ago

    Hi foodd.


    I can only see PivotTable. (See the second screenshot in my original post.)

    The Power BI dataset is connected to multiple sources, a mixture of different Web APIs, and some Excel files.

  • bi_analytics's avatar
    bi_analytics
    Frequent Visitor
    2 years ago

    Does anyone know how to fix this problem?

  • Martaspg's avatar
    Martaspg
    Icon for Advocate I rankAdvocate I
    2 years ago

    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,