Is there any library to operate PowerBI by RF? Where can I find the demo for PowerBI RPA Automation

Robot Framework
1

I am trying to refresh and publish PowerBI by RF - RPA.Windows.
But it is hard to detect how long it will take when the mouse click these button, so I come here for help.

2

Hi Paul,

From here → Microsoft Power BI - Wikipedia

Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence.(Microsoft Power BI - Wikipedia) It is part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Data may be input by reading directly from a database, webpage, PDF, or structured files such as spreadsheets, CSV, XML, and JSON.

So to cover everything you’ll probably need several libraries, but from what I remember of Power BI it’s mostly accessed through a web browser, so SeleniumLibrary or Browser Library would probably be the best place to start.

Beyond that, depending on what you need to do some other useful libraries might be:

That should cover everything in Power BI, but if I missed anything just say what and I’ll try and find a suitable library.

Dave.

3

Thank you Dave,

I am handling PowerBI Desktop, It is an application on Windows Desktop.
I am trying to use Accessibility Insight/FlaUInspect to inspect windows element(AutomationId/Name…), and use RPA.Windows to handle RPA automation, but failed.

Now I am trying to use FlaUILibrary.

But I still don’t know how to wait ModalWindow finished - Refresh action will popup a ModalWindow and will disappear refresh action completed - The ModalWindow duration could not be estimated.

I don’t know if anyone encountered same issue and have a better solution to handle such scene.

4

Hi Paul,

Well if you can identify the model window somehow even if it’s just the window title, the obvious answer would be use Wait Until Element Is Visible first to make sure the model window appears, then use Wait Until Element Is Hidden to wait for it to close.

  • FlaUILibrary would be my first choice when dealing with a windows desktop app, you could also try whitelibrary but that was replaced by FlaUILibrary and I believe whitelibrary is no longer maintained.
  • Next in the list of libraries to look at would be AutoitLibrary

If you’re still not having success, then there are the two image libraries that should work on any app

With one of these libraries or by combining them you should be able to acheive what you need.

Dave.