cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandeep540 Frequent Visitor
Frequent Visitor

indexing a dataset in power bi cloud for faster processing

If I upload a dataset with 40 columns and 1 million rows, which is output of joining 5-6 tables in db! Once published the dataset resides in cloud for mashup!

 

Now I want to make sure the report being generated using the dataset is rendered fast without any lag or buffering! For this is it possible to create my own index (or indices) on the dataset for quick processing!

 

Please share your thoughts!

4 REPLIES 4
ankitpatira Super Contributor
Super Contributor

Re: indexing a dataset in power bi cloud for faster processing

@sandeep540 I don't think you can create indexes on the dataset that is published in cloud nor can you do that in power bi desktop. You may not have any performance related problems since your data is up in cloud ready to be visualised in cloud. However you will experience longer time in getting that data refreshed from data source.

ashishrj Senior Member
Senior Member

Re: indexing a dataset in power bi cloud for faster processing

@sandeep540 You cannot create indexes in Power BI dataset as in SQL DB but you can connect your datatset using direct query for faster processing and querying !

ankitpatira Super Contributor
Super Contributor

Re: indexing a dataset in power bi cloud for faster processing

@ashishrj DirectQuery doesn't mean faster processing and querying. It is mechanism to keep your data on premise if you can't publish to cloud. Using Import method would be faster as data is is cloud and cached which you don't get with DirectQuery.

 

Highlighted
felyoubi Regular Visitor
Regular Visitor

Re: indexing a dataset in power bi cloud for faster processing

Hi,

 

A dataset with 40 columns and 1 million rows is nothing to worry about. The Azure engine what poweres Power BI Service can process your data any level your want. However, there is a concern if you have all of that in our table, aggregating, grouping, etc... will take some processing time as with any tool. If this is the setup you have, I suggest you break the single table into multiple tables and map out the relationship. That will definitely help.

 

Regards,

Fahd

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 59 members 1,235 guests
Please welcome our newest community members: