Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Use excel table inserted in dataset

Hi! We are having problems reaching a server (problem with server conection not a power bi error), we are are trying to remove this conection and insert the excel table in the dataset.

 

We tried hardcoding using the "Enter data" option and copy-pasting the table as our first option , but we found that the limit was 3000 cells per time. So my question is, Could be possible to "insert" an excel table in our dataset without importing from excel or other source? 

 

Thanks!

 

Need Help

1 Reply

  • ToddChitt's avatar
    ToddChitt
    Super User
    4 years ago

    Unfortunately no. 

    If you can get to the data itself, try this:

    1. Extract it to its own file.
    2. In Power BI Service, create a Dataflow to load this data (you will need a file connection on your Gateway to get to it)
    3. consume that Dataflow dataset in your report