Forum Discussion

IamTDR's avatar
IamTDR
Responsive Resident
4 years ago
Solved

Dataset from Report Service to Excel as a Table

Just double checking to see if I am understanding this correctly. 1. Create Dataset using Power BI Desktop 2. Publish to Power BI Service 3. Open Excel on desktop and then connect to dataset (Data...
Need Help
Tutorial Requests
  • IamTDR's avatar
    IamTDR
    4 years ago

    Figured this out yesterday.  Noting the steps I took in case anyone else is interested.


    Connect Power BI Dataset to Excel as a Table (Not Standard Pivot Table)
    1. Open Excel file and Connect to Power BI Dataset
    2. Create a Pivot Table w a Measure Included
    3. Double Click on Measure results in Pivot Table and follow to next Screen
    4. Right-Click within table and Select 'Edit Query'
    5. Within Query Content type "Evaluate tablename" (Note no text characters in front of table name)
    6. Original Pivot Table can now be Deleted
    7. Data Connections, good practice to rename Connection

IamTDR's avatar
IamTDR
Responsive Resident
4 years ago

Figured this out yesterday.  Noting the steps I took in case anyone else is interested.


Connect Power BI Dataset to Excel as a Table (Not Standard Pivot Table)
1. Open Excel file and Connect to Power BI Dataset
2. Create a Pivot Table w a Measure Included
3. Double Click on Measure results in Pivot Table and follow to next Screen
4. Right-Click within table and Select 'Edit Query'
5. Within Query Content type "Evaluate tablename" (Note no text characters in front of table name)
6. Original Pivot Table can now be Deleted
7. Data Connections, good practice to rename Connection