Simple Power BI Stuff

Old fashioned form analyzing requires extra protection. Forms is a handy tool to collect user input for various purposes. You can check the results directly from Forms service online, but for more in depth analytics the results can be downloaded in an Excel file. That means that the results can be interpreted and refined in Power BI with ease. So, let's get on to it. Create a form with Forms If you haven't had the chance to create forms with Forms before, there's no need to be afraid. It's really straight forward, so I won't go through the process here. Really, there's nothing to it. There's plenty of tutorials out there. For example check out Kevin's excellent video on the subject:  How to use Microsoft Forms Get form id The part we are interested in your newly created questionnaire is the form id . Open you form if it isn't open already in editor or in preview. Check the URL from the browser and look for part starting with  FormId= Starting aft...

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...

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.