Forum Discussion
Transform Org Flat File Into Power BI Star Schema
I have a large flat file in Excel. I'm going to break it up into 5 tables in a star schema format. No questions there. The data model is sound, one-to-many fact to dimension relationship, primary ...
Yes.
There could be problems if some of the data doesn't conform to the same pattern/types as the original data , for example, a text value in a number column would break a 'change type' step .
This is just an example, I'm not saying it's going to happen but should be fine.
Thank you very much. So this is best case scenario. My goal is that no data types will change. I am however adding a number of new conditional columns in the transformation as weel, I'm assuming those will fire off and get created during the refresh as well with no problems ?
