Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

PowerBI Extract

Would like to share the data without all the database connection nor my report.   In Tableau, there is a concept of Tableau extract file and you can load xx rows and share the extract files.  Is th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-danhe-msft, thanks for the feedback.  I was hoping to extract just sample data.  You can read about it here.  Context of what I am trying to do is that I am doing some work on our data warehouse.  I would like to import some sample data and send my collegue the base relationships, etc so she can work with it and create the visualization that she wants without needing to connect to the underlying data source.

 

Also based on my limited experience with PowerBI, it seems like when I import, I am importing the entire table and I didn't see a way to limit the number of rows.  Did I miss a feature?

 

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous,

For your first issue, based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum:https://ideas.powerbi.com/forums/265200-power-bi-ideas

For your seconde issue, it based on different data source, for example, when you get data from sql server, you could get beow view and enter T-SQL statement to select the Top 10 rows:

Also you could clean your data in query editor:

Hope it could help you.

 

Regards,

Daniel He