Forum Discussion

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
4 years ago
Solved

Different context in Excel & PBI Desktop when using PBI Shared Dataset

Hello everyone,   I am using the Power BI shared dataset as a datasource in the Excel, and we have been trying to plot a simple tabular data in the Excel. We are using fields from multiple tables ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, rajulshah 

     

    Here are things to keep in mind for connecting to Power BI datasets in Excel:

    • Excel PivotTables don't support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures.

     

    Considerations and limitations:

    refer:

    Connect Excel to Power BI datasets

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

rajulshah , can share some screenshot, and measure formula's used