14 Nov 2024
Bring Premium Reporting and Token Flex Usage to Power BI
You may have already seen our GitHub repository with sample code of custom visuals and data connectors for Power BI. Now, if you happen to be using Premium Reporting API or Token Flex Usage Data API, we're excited to announce that the repository now includes experimental data connectors for these as well!
Premium Reporting
The Premium Reporting API Connector lets users pick one of the predefined usage queries, and import the results into their local Power BI Desktop app. Since the connector must be built for a specific APS Client ID, we don't provide a ready-to-use *.mez file, however the build process is quite straightforward, even if you're not a PowerQuery guru (I'm certainly not 😅). The prerequisites and build steps are explained in the README, and we also have this fancy video demonstrating the process:
If you are familiar with PowerQuery development, or you feel adventurous, feel free to fork the repository, and extend the connector with additional Premium Reporting queries.
Token Flex Usage Data
The Token Flex API Connector provides the exact same user experience as the previous one, with just one example Token Flex usage query. And just like with the Premium Reporting API Connector, you'll need to build this connector with your own APS Client ID, following the README and this breathtaking video:
Have fun! And if you run into any issues, or perhaps have some ideas about additional features that would be generally useful, do let us know here.