Display Power BI dataset sa a table in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2770309%22%20slang%3D%22en-US%22%3EDisplay%20Power%20BI%20dataset%20sa%20a%20table%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2770309%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20trying%20to%20get%20data%20from%20a%20published%20Power%20BI%20Dataset%20into%20an%20excel%20table%20because%20I%20need%20it%20to%20be%20formatted%20as%20a%20table%2C%20not%20a%20pivot%20table.%3C%2FP%3E%3CP%3EI%20couldn't%20find%20any%20option%20to%20load%20Power%20BI%20dataset%20to%20table.%26nbsp%3B%20It%20always%20loads%20as%20a%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20%3F%26nbsp%3B%20Or%20am%20I%20just%20asking%20too%20much%3F%26nbsp%3B%20Or%20maybe%20not%20using%20the%20right%20tool%20to%20create%20data%20exports%20to%20Excel%3F%26nbsp%3B%20(csv%20exports%20from%20Power%20BI%20service%20reports%20aren't%20that%20easy%20to%20use%20for%20our%20end%20users)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2770309%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi,

 

I was trying to get data from a published Power BI Dataset into an excel table because I need it to be formatted as a table, not a pivot table.

I couldn't find any option to load Power BI dataset to table.  It always loads as a pivot table.

 

Any ideas ?  Or am I just asking too much?  Or maybe not using the right tool to create data exports to Excel?  (csv exports from Power BI service reports aren't that easy to use for our end users)

1 Reply

@Pascal Bellerose 

 

did you try getting the data using power query in excel?