Forum Discussion

POUYA's avatar
POUYA
Frequent Visitor
4 years ago

import large table (view )

Hello everyone,

 

our bussines model is to develope and keep all tables and view in azurze synpase and then user can connect to synapse and get data.

my problem is with one table which is extrmely big(its view actully) , Im trying to import this table and then publish it power bi service , so user can conncet and bulid dashboard. but this table (view) is so big that i can not import it, and i cant make model in power bi either due to our business model. since both service are belongs to microsoft i was wondering if there is any soultion.

our in general if there is any solution for how to import view to power bi

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    You can consider using incremental refresh partitions, either with a dataset, or even with a dataflow if you are concerned about re-usability.

     

    Another option is to materialize the view so you get better spooling performance.

  • POUYA's avatar
    POUYA
    Frequent Visitor
    4 years ago

    thank you for reponds, but solution such as materialize is not option.

    we want to simply make extarct of this view in power bi service and then let user bulid dashboard out it , based on thier need and department. 

    its big view to start with , incremnetal refresh might be useful after we be able to make intial extract and send it to PBI Service