Forum Discussion

amalekshahi's avatar
amalekshahi
Frequent Visitor
7 years ago

ADL Gen 2 & CDM & Dataflow & PBI refresh and data type questions

Hello, To work around the issues we had with importing our large fact table (1.6 billion rows) into PBI, I decided to try my own ADL Gen 2 and use dataflow. My plan was to breakdown the fact table ...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi amalekshahi ,

For your first requirement, it seems that you could set schedule refersh for dataflow under setting in power bi service.

In addition, you could enable incremental refresh for dataflow entities to refresh yesterday's data only if you using Power BI Premium capacity. 

More details, please refer to this blog which should be much helpful.

For your second requirement, I'm afraid that there should be no options for us to pecify int32 as a data type in CDM by my research.

Best  Regards,

Cherry

 

amalekshahi's avatar
amalekshahi
Frequent Visitor
7 years ago

Hi Cherry,

PBI Service scheduled refresh on dataset level will refresh all partitions in the CDM folder. I just need the last partition to be refreshed. Also, the incremental refresh feature on dataflow level is disabled for "external" dataflows (dataflows on ADL Gen2).

Thanks