Data Stage in Power BI

[Anonymous]

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?

[v-diye-msft · Accepted solution]

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