Forum Discussion

selected_'s avatar
selected_
Helper IV
5 years ago
Solved

How to collect the data into one source?

I have multiple data sources that comes from diffrent software. Today I export each of data from these software services as Excel files and then visualze it in Power BI.  Now I don't do this job man...
Need Help
Show and Tell
Tips and Tricks
  • collinq's avatar
    collinq
    5 years ago

    Hi selected_ ,

     

    I guess you could use Dataflows or other techniques but you could just use Power BI - and connect to each data source and combine them as needed in Power BI.  You don't need an intermediate step.  If you want to do that functionality in a Dataflow you could (and that might be efficient if you have reasons to do so).  

    Setting the refresh to run automatically in Power BI Service will keep the data updated.

collinq's avatar
collinq
Super User
5 years ago

Hi selected_ ,

 

I guess you could use Dataflows or other techniques but you could just use Power BI - and connect to each data source and combine them as needed in Power BI.  You don't need an intermediate step.  If you want to do that functionality in a Dataflow you could (and that might be efficient if you have reasons to do so).  

Setting the refresh to run automatically in Power BI Service will keep the data updated.