Forum Discussion
Help with Dimension update with data comming from a huge data source
Hi Anonymous
The question would be better, why do you want to use dataflows? What do you want to achieve? How do you want to connect to your data? how are you going to refresh your reports? Why thinking of premium instead of Pro? who is going to use your reports? with whom are you going to share it? and many more questions need to be answered before engaging into Power Bi.
Sometimes a Free license could do the work but for sure Premium is not an option for you now unless you would have more than 500 users in your organization that are going to use your reports.
Hello, aj1973
I use Dataflows to be able to store the entities in CDM (with an associated storage account) since Power BI datasets have size limitations that I believe would be surpassed in this case.
Also is a requirement for this data to be available to other users, clients, or applications that at some point in the future would want to use it.
In my post I mention that I have a PRO subscription. I explain that my initial approach was to get the new data and append it into an existing entity, something that is only available in Premium subscription (if you want it to refresh it). Then I explain that I learned about Power Platform Dataflows and I ask for an opinion about it, if this would be a good alternative since it enables to create and refresh Computed Entities.
Then I wonder if this is a good approach (get delta data and append) or is there a better way to deal with dimensions in a scenario with large source datasets (the idea would be to avoid query the whole underlying log)