Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More

Memberships

Learn Microsoft Fabric

Public ā€¢ 6.5k ā€¢ Free

1 contribution to Learn Microsoft Fabric
Help Needed: Pipeline->Dataflows->Lakehouse->PowerBI
In the pre Fabric days is when I was fairly good with PowerBI and would use the Desktop for all the steps of importing data, transforming and then creating reports. The client I am working with has Fabric and we want to do it "properly" but find I am getting lost with a few stages. I have a workspace with the premium feature enabled with the diamond icon Can someone explain, if this is possible? I may have the steps or technical terms mixed up, but this is my general understanding of what I'm trying to achieve: 1. Import an on premise SQL into Fabric (Datapipeline?) 2. create a Lakehouse for this data 3. Transform and clean the data (Dataflow) 4. have a custom (or default) semantic model attached 5. Import the Lakehouse as a data source into PowerBI Desktop so that it inherits the semantic model AND data 6. Create reports/dashboards in Desktop 7. Publish: Once reports/dashboards are published they are refreshed based on the Lakehouse (frequency set by the Dataflow?) 8. Be able to modify the entire workflow as the needs evolve At the moment this last step (modify the workflow) seems to be the hardest part... If this is too vague then I can provide some specific examples of the steps in which I feel like I am close to achieving this but am blocked. Thanks!
2
4
New comment 26d ago
1 like ā€¢ Nov 19
Nice! Thanks @Wilfred Kihara this is boosting my confidence as I think I am on the right path. #8 I guess is if I understand that the reports need more work and customization and I eitgher need to bring in more tables or even more datasources, but ultimately have it update across all the components (pipelines, dataflow gen 2, lakehouse default semantic models and then sync to the PowerBI semantic models. I imagine that I will need to iterate on this as the team continues to work on the reports and dashboards collectively. I'm going to try your suggestion. Thanks!
1-1 of 1
Bart Sullivan
1
2points to level up
@bart-sullivan-7155
Learning MS Fabric

Active 8d ago
Joined Nov 13, 2024
powered by