transform data

3 Topics

Power Query Refreshing
Hey everyone! I'm new to the Power BI Community and I'm running into an unexpected issue. I'm using Power BI Report Server and connected to and importing a table from Oracle DB. The problem is, everytime I edit a column or make any tranformation within the data(e.g Replace values), it refreshes the data from the data source, reading the complete database each time and reapplying the filters. As you can imagine, with millions of rows this is causing immense wastage of time and is a serious set back for us. Is this supposed to happen? Or could I be doing something wrong?
Pbiguy4u
3 years ago Place Report Server
346Views
0likes
0Comments
Transform DATA
Hi All, Below is the problem statement. Need help with this. I have a a data set with One of the rows containg Date. I want to import the data which has only the latest date. New rows with latest date keep getting added everyday. Whenever the Dahsboard refreshes, I want the data which has the latest date (only one date). That date is not necessarily yesterday, it could be anything but has to be the latest date. Can someone help me build this logic? regards, Santosh
Solved
santoshreddyk95
4 years ago Place DAX Commands and Tips
681Views
0likes
1Comment
Transposing / Transforming data with DAX
I want to transform the data from this format: ID CaseNumber Asset1 Asset2 AA BB 1 2 CC DD 3 4 To this format: ID CaseNumber Asset Value AA BB Asset1 1 AA BB Asset2 2 CC DD Asset1 3 CC DD Asset2 4 Since columns Asset1, Asset2, Asset3, etc. are calculated column in DAX I cannot use PowerQuery to unpivot the data. Let me know any solutions with DAX. Thanks!!
Solved
mariajuliao
4 years ago Place DAX Commands and Tips
1.1KViews
0likes
5Comments