Forum Discussion

DarinSpence's avatar
DarinSpence
Icon for Helper II rankHelper II
5 years ago
Solved

Steamline Creating of Separate Data Model-only PBIX file

I created a PBIX report file that I use on multiple data sets. To that end, I've created a separate file for the data model. This way, I can ETL data from different clients into a separate data model...
Tips and Tricks
  • ElizabethTachji's avatar
    ElizabethTachji
    5 years ago

    Dataflows come with Pro license and uses Power Query.  You dont need a datawarehouse

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

"I've found it to be very tedious to take totally different data sets and get them shaped into the correct data model each and every time. "

 

Welcome to the club, I guess?  Unless you have good company wide data stewardship (and I have yet to see a real world example) that work - getting the data model right - will continue to occupy most of your time.  Reporting is 95% data preparation and 5% presentation.

  • DarinSpence's avatar
    DarinSpence
    Icon for Helper II rankHelper II
    5 years ago

    Ha, thanks!  I probably need a standard data warehouse so I can connect and re-use the PBIX file with the reports. 

     

    I've gotten pretty comfortable with Power Query and would like to use something like that to ETL into a data warehouse. 

     

    I've also thought about getting a Power BI Premium User account and using Data Flows.