Simple Power BI Stuff

Use dataflows to organize your work and to separate ETL from visualizations. Trust me, for I'm a stranger you found in a blog, this will change your report designing habits for good. Your lineage should go from data source(s) to PBI report/dashboard/app like this:      DS --> Dataflow -> Report Datasources can be wherever they might be as long as you can connect to them from the PBI Desktop and PBI Service. Dataflow will be designed in the Power Query Editor of  PBI Desktop and in the Model and Data views of PBI Desktop and published in PBI Service. Report will be designed in the Power Query Editor of PBI Desktop and in the Model, Data and Report views of PBI Desktop and published in PBI Service. The above stunning graph in more verbose format: Connect to your data source(s). Get the raw'ish data. Do the thing in the Power Query. Do the cleaning, transformations etc. Make the data so good that there's nothing for the usual end user to tinker. Disable all the loads

Hi. So this is how it goes. I make living out of Power BI reports. I do mostly visual design, but ETL and the whole process starting from defining KPIs with customers to hands on training them how to use the reports falls into my lap. I use this blog as a personal notebook for stuff I have found of interest. By sharing my thoughts I think I could help some of you fellow Power BI users out or at least give something to think about. I'll keep the threshold to post stuff really low. I mean really, really low. Like there's no threshold. If something comes to mind, I'll post it. So let's get to business.