Thanks very much for you email.
So to be clear Microsoft BI cannot do what eg Alteryx and Tableau working together can do?
...With Alteryx you can clean and transform data (eg results for last week) and then upload the processed data to a database
...With Tableau you can then read in and visualize all of the data
Is the case that with BI you can only:
...Process data (using Power Pivots etc) and visualize that or
...Read data from a database and visualize that
Be great to understand how this works as its a key distinction for us if we are to evaluate BI....