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