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

Question

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'

Answer 1

Done

https://learn.microsoft.com/en-us/answers/questions/2121829/excel-python-anaconda-why-is-microsofts-powerbicli

Answer 2

I'd suggest you create a new thread on Office Development which is special channel to handle such issue.

Office Development - Microsoft Q&A 

Thank you for your understanding!