Forum Discussion
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 b...
ankitpatira
Community Champion
Community Championashishrj 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.
felyoubi
Kudo Collector
Kudo CollectorHi,
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