Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Historic data (last 4 days data), dataflow vs dataset ?

    I have premium capacity p1 workspace   I have an oracle pipeline query that gets data for the previous working day only (more than a million rows) business need is to get data , at any given...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Can you just close this thread by accepting it, if it is solved

    Thanks

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Your questions are really clear;

"what should be the best possible approach for this, is dataflow a better approach ?"

Better approach than what?

"i am right now experimenting with power bi dataset import mode, since 30 minutes screen shows loading from...so i think its loading into azure ?"
Are you talking about after publishing to the service or in your desktop?

"how do I get historic data into my report if the business need is to get data for last 4 days ?"

Are you talking about how to refresh your report?

 

please suggest how to show historic data in the report ?

It depends where the source is, a Gateway is a solution

 

and if dataflow is faster compared to dataset ?

Can't campare as the Dataflow will become the source for your dataset.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This (below screenshot) is in power bi desktop import mode, does that mean the data is being loaded into azure ?

     

     

     

     

    • aj1973's avatar
      aj1973
      Icon for Community Champion rankCommunity Champion
      5 years ago

      No, It's been loaded into your desktop, into the Dataset File.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        So my data is 3 million rows, takes forever to load in the power bi desktop. (import mode)

         

        is it going to be the same refresh time when I upload it to service (import mode)