Forum Discussion
Helper IIExpert opinion on Incremental refresh choice
Yes, as long as you remember there will be no performance benefit from incremental refresh. Your only benefit will be the unlimited size ( well, 10 GB per partition) and the partition management .
I dont think theres anything like a "deadline" anyways right?"I love deadlines. I love the whooshing sound they make when they pass by." DNA
Helper IIHi lbendlin
Im not sure I understand correctly, or maybe I actually didnt explain myself accurately. The Blob storage is not a "static storage" new files will be coming in each day at a pretty reasonable rate. On the other end of the process the idea is to refresh the end dashboard as frequently as possible ( my aim is daily but if completly impossible I can go with every 2 or three days).
Does it make sense what I want to obtain? otherwise I really dont see how can I ignore incremental refresh
Many thanks!
- lbendlin
Super User
Place the files in a Fabric and access them via Direct Lake connection.
Note: while technically being an option this will incur additional cost.
- AutoJL
🤣 Sorry that I keep messing up. I only mentioned PowerBI tools as they are they only things I have at hand. I do not have access to a Fabric capacity yet (this is a corporate company decision and unbelievably they didnt go with it yet).
I know using only PowerBI tools is totally suboptimal but its what I have sadly, is there no way to even attempt this?
Thanks!
- lbendlin
Connect your Semantic Model to the Azure Blob Storage directly. (Caveat must be in the same region)
Azure Blob Storage - Power Query | Microsoft Learn
I hope you are aware that your Power BI Premium days are counting down, and you have to migrate to Fabric if you want it or not.