Excel python anaconda - why is Microsoft's powerbiclient package not included?

Mike Honey 116 Reputation points
2024-11-21T21:11:33.4866667+00:00

Trying the Excel Addin "Anaconda Code" for python. https://support.microsoft.com/en-au/office/open-source-libraries-and-python-in-excel-c817c897-41db-40a1-b9f3-d5ffe6d1bf3e

The Addin installed OK. But the first code I wanted to try uses Microsoft's powerbiclient library (e.g. to connect to a Power BI Report and retrieve data).

But the first lines of python code needed:

from powerbiclient.authentication import DeviceCodeLoginAuthentication

... throw errors indicating this scenario is not supported?

Can the left hand please talk to the right hand and sort this out.


Traceback (most recent call last):

File "Sheet5!A1", line 1, in <module>

from powerbiclient.authentication import DeviceCodeLoginAuthentication

ModuleNotFoundError: No module named 'powerbiclient'

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,024 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.