Category : powerbi

I have the following python code which works fine on first execution. import adodbapi # Connection string conn = adodbapi.connect(""" Provider=MSOLAP.8; Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, 929d0ec0-7a41-4b1e-bc7c-b754a28bddcc; Data Source=pbiazure://api.powerbi.com; Initial Catalog=[dataset_id]; User Id=[username]; Password=[pass]; """) # Example query print(‘The tables in your database are:’) for name in conn.get_table_names(): print(name) conn.close() However when it try to run it ..

Read more

I am trying to get all Power BI desktop components using rpaframework library from RPA.Desktop.Windows, but the automation_id returned is empty for most of the Power BI window components. Have shown result that below I get for few window components such as Close and Getdata. ([<uia_controls.StaticWrapper – ‘Get data’, Static, 8881667776078132027>, <uia_controls.ButtonWrapper – ‘Close’, Button, ..

Read more

I wrote this code to calculate the final stock; the problem is that I want to apply a loop on ‘code article’ and ‘division’. Each article in one of its two divisions has its own stock The stock of the article in the 2 divisions is independent # ‘dataset’ holds the input data for this ..

Read more