Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I created some dataflows and now I am attempting to create some "sub-dataflows" from those dataflows. When I select dataflow as the source, however, it asks for the gateway information. I provide the gateway. Under Authentication kind, I cannot select anything and I cannot select "Next" to continue. The other dataflows are using the same gateway so I don't know what else I need to do.
In case anyone has other suggestions, my goal is this:
I have created dataflows with a ton of data. I've set up incremental refesh on this data. Several reports can now use these dataflows, but they don't need all the data. Therefore, I load this data into Power BI desktop and set filters there. I'm new to this method so I could be incorrect, but I believe when I save the file, the file size is based on the filtered data. This is good. However, when I refresh the data in desktop, it takes forever, which leads me to believe it is still pulling in all of the data before filtering. Either that or it just takes that long to filter the data. So the plan was to create these "sub-dataflows" which would be filtered versions of the original dataflows.
So, overall I'm looking to:
1. Utilize incremental refresh
2. Keep desktop file size as small as possible
3. Keep desktop refresh as fast as possible
Solved! Go to Solution.
Would you not be better off building your dataflow structure from smallest granularity to the greatest rather than complete to subset? By that I mean say you were looking at sales data and wanted to subfilter by year in your example. Would it not be feasable to create the following:
Dataflow A with last years sales
Dataflow B with current years data
Then either in dataflow C through a linked entity you append A and B or have the combine be done in the Power BI file.
This would mean you meerly change the source in the dataset depending on your requirements.
@GilbertQ- what do you mean by "Star Schema"?
I do use the method you described for some other reports - connecting desktop reports to datasets in Power BI Service. The downside, from what I can tell, is that I am limited as to what I can do with these desktop reports. I can create measures, but I cannot create calculated columns.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |