@ excel table

2 Topics

Selecting cells, copying / pasting from Power BI into Excel
Hi there, I am new to Power BI. I am an end user and need the data displayed in Power BI to obtain data and write reports. I feel frustrated because there appears to be no easy way to drag and select tables, or multiple cells in a table, to copy and paste in the same format in excel. If I copy the table, the format it is pasted in in Excel is very difficult to sort out. If there are multiple slicers, I seem to have to copy the table for each individual slicer separately to get the data in excel. Is there not an easier way to export the data in excel exactly as displayed in Power BI? Or even a way to quickly select cells in the table to copy / paste? I am using Power BI Report Server, not the Desktop app.
Solved
canost
1 year ago Place Report Server
2.2KViews
0likes
4Comments
Importing file from a server vs. desktop
I'm trying to create new query importing from excel table, not from excel sheet. First, I created and named "table1" as below. (No Prob.) Then, once I uploaded the excel file on "Power BI Server", and imported the file to a new query, I couldn't find "table1" that I just made. (Problem!!) So I tested by importing the file from my desktop directly, then I found "table1" and 3 more columns (No Prob.) ※ The Question is : 1. Why the commands from the server & desktop call different items and colums? 2. Is there any way to call "table1" importing data from the server?
SanCho1
2 years ago Place Report Server
629Views
0likes
2Comments