Forum Discussion
Display Power BI dataset sa a table in Excel
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 da...
Finally, if you need few tables to import or add them the existing file. Create connection as in previous post and export it as ODC file from properties. You may copy/paste such files editing them in Notepad to define another tables (or create one by one and export in Excel).
Open new file, Data -> Existing connections -> Browse for more -> select proper odc file->open to table. Repeat to add all tables from saved ODC.