More Power BI API awesomeness, now on PowerShell & SmartCharts
March 17, 2015 Leave a comment
Amazing week for Data lovers & Business Intelligence minds, Power BI Preview is now *globally* available! Be sure to check out the public announcement for details. And Chris Webb’s BI blog for additional insights.
By now you know that there’s a new & strong developer story for the new Power BI, and even if at the moment we have a simple API to test drive, it already allows to think of interesting scenarios. Particularly for real-time dashboards or the click to insights pattern I happen to obsess so much ….
Really, seems there will be no place for data to hide from Power BI :). When Power BI can’t get there… we will bring it to Power BI in a blink of an eye, in real time if needed, all using the brand new APIs.
Don’t have Power BI Designer? or even Excel? and need to quick load some data to explore? Real time? Check out DevScope github & use the awesome Power BI API Powershell modules to load your Data into PowerBI directly from the command line (for more info & a cool real time sample don’t miss Rui Romano blog post).
Adding that, as of… now :) you can also use SmartCharts to quick send & live sync to Power BI directly from Excel. :)
Start with your data as usual or the sample dataset and just click Send To Power BI.
Authenticate & authorize the app for Power BI access, choose a Dataset and a table name :
and your data will be available in your Power BI account ready to more Power BI awesomeness
(note: if using date/time columns we also add some extra time related columns we happen to use in the app).
Your data ready to explore in Power BI:
Noting that you should be able to do all this on trial mode without any restrictions. Got feedback and requests? let us know (there’s a feedback form in the app :) we will get back to you)
If you want to know more about the new APIs, some additional recommended reading:
- Power BI Developer Center
- Power BI Developer blog
- Power BI team github
- Richard diZerega – Building Apps with the new Power BI APIs
- Power BI API adapter for Apache Spark
- Pushing Data into Power BI Preview Using the New REST API – Part 1
- Pushing Data into Power BI Preview Using the New REST API – Part 2
- DevScope’s awesome PowerShell module for Power BI API’s
- TechNet Wiki : PowerBI Api in .Net (en-US)
More to come :) stay tuned