Forum Discussion
Data Stage in Power BI
Hi
I used to develop in QlikView, and I'm new in Power BI.
In that tool, to avoid overloading the database, I downloaded all the data "as-is" from the database into a qvd file.
Then I used that qvd file to apply al the transformation needed. In that way, I just make one query to my data, and refresh it just if needed.
Something like this:
1 Database
2 QVD (Stored Data in Qlikview format)
3 Script to Load Data from Database
4 Script to Transform Data and Visualize it
In power BI, every time that I do a relatively small change to data, I have to download all the data again. Is there any way to do something like the Data Stage in QlikView?
Hi Anonymous
You can do the data transformation in power query:https://docs.microsoft.com/en-us/power-bi/desktop-query-overview
Power Query is a data processing & mashup software. We can use Power Query to
- Connect to several types of data sources (databases, files, web pages, social media, APIs, cloud storage etc.)
- Bring and combine data (append, merge, join etc.) from various places
- Derive new columns of data
- Format, remove or reduce data
- Reshape data (transposing, grouping, pivoting, un-pivoting and other creative ways)
- Write formulas to do advanced manipulation of data
- Publish refreshable datasets
1 Reply
- v-diye-msft
Community Support
Hi Anonymous
You can do the data transformation in power query:https://docs.microsoft.com/en-us/power-bi/desktop-query-overview
Power Query is a data processing & mashup software. We can use Power Query to
- Connect to several types of data sources (databases, files, web pages, social media, APIs, cloud storage etc.)
- Bring and combine data (append, merge, join etc.) from various places
- Derive new columns of data
- Format, remove or reduce data
- Reshape data (transposing, grouping, pivoting, un-pivoting and other creative ways)
- Write formulas to do advanced manipulation of data
- Publish refreshable datasets