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)

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

        Anonymous 

         

        Not sure about 3 million rows will take for ever! besides you are gonna have to do some ETL to your data, and build a dataset. You are gonna keep only the data you need for your reports. Direct Query mode is another way to bring your data.

         

        Refreshing the data in the service: there are other techinques to make the refresh takes less time, like using paramaters or incremental refresh.