Forum Discussion

webchris's avatar
webchris
Advocate III
2 years ago

Power BI Dataflow - Power BI Dataset

Hi there   I am currently facing issues with Dataflows in combination with Datasets.   In my Dataflow I had, a while ago, an property with 3 different records. I changed the queries, rebuild the ...
Dataflow
Need Help
webchris's avatar
webchris
Advocate III
2 years ago

I am querying results for Properties (in this case Buildings). In the Dataflow, I get 1 record as a result for a specific Property (Building). This Property is allocated to one Fund (therefore 1 record).

A while a go that Property was allocated to 3 Funds, which was okay at that time, but is no longer. 

 

But when I query this Dataflow, I get the results which was valid a while ago. Although I refreshed everything several times...

 

 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    What is the data source for your dataflow?

    • webchris's avatar
      webchris
      Advocate III
      2 years ago

      First Dataflow has Salesforce as a Source.

      This is an "old" fashioned Dataflow which works properly (no problem as in the other topic) - this is my daily "staging".

       

      The second flow queries the first Dataflow and contains some transformations and calculations. So far, that ran fine and did not cause issues (untill 3.5 weeks back).

       

      The Dataset queries the second flow.

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Too many moving parts, in my personal opinion. I don't think dataflows are providing any meaningful benefit for a Salesforce data source.  For example, I have a 30 GB dataset with incremental refresh fed from a SFDC object query.  I cannot imagine what the effort would be to have two dataflows feeding that dataset.