Forum Discussion
PBI DataFlows Oracle partitions In-Memory mode
Hi PBI Team! Is there a way to see somehow partitions in PBI DataFlows(IM mode, Oracle data source)? Is it stored somewhere in azure blob or data lake?
I have read a few related articles here in Microsoft Power BI Community Forum and my understanding is: this is not archivabale task ->have opportunity to see partitions in pbi online DF UI and make changes manually)
Am I missing smth here?
Is it right assumption?
Thank you in advance
3 Replies
There was once someone over at the Power Automate forums who reverse engineered the dataflow storage location. Pretty impressive but also rather pointless. What are you trying to achieve?
Hi lbendlin
I am trying to implement more advanced partitions and refresh scenarious through XMLA endpoint
1) how to see/manage partitions? SSMS only provides option to see tables inside dataset, ATM and Tabular Editor app are not considered safe to use for now
2) updating a few partitions instead of full refresh /for big dataset ~8G/ Large DataSet option is turn on. Also solution migraties to DataFlows. Is there a way to manage partitions inside DataFlows UI? I have not find it at current state
There is very little documentation on that, not much beyond
Using incremental refresh with dataflows - Power Query | Microsoft Learn
and
Understand and optimize dataflows refresh - Power BI | Microsoft Learn
I have yet to find documentation on how to bootstrap dataflow partitions. In my business scenario I have had to abandon dataflows entirely and implement the partition management in datasets instead.
