PowerApps license for Power BI - DirectQuery sources
We have E3 licenses so we have access to run STANDARD Connectors in Power Apps and hence we can create simple forms that are embedded in Power BI using the likes of SharePoint.
Unfortunately the only way to get that immediate feedback in Power BI is to use a DirectQuery source...
Publish to web - 'organizational visuals'
We found to our cost that reports that have been 'published to web' will block visuals if you have set 'block non certified' visuals in PBI admin settings.
This is even the case if you have approved a visual as an 'organizational' one.
P2W only checks if...
ODS files
ODS file structures are becoming more and more common.
Excel recognises the ODS format but Power Query doesn't appear to be able to read ODS files.
I've read that they can be read using some native M functions but Power Query should be able to handle ODS files as it does...