Issue with python connection

[nabgre]

Hi all,

I'm currently encountering an issue when trying to connect my Python code with Power BI.

Interestingly, all Python code I execute runs successfully in Visual Studio Code, but I'm encountering difficulties when attempting to retrieve the associated table in Power BI.

Below is an example of code that runs smoothly in Visual Studio Code:

The same code, when implemented in Power BI, does not display any table.

I'm seeking your support to resolve this matter.

Regards

[nabgre]

Hi @lbendlin,

thanks for replying to me. 

I'm trying to retrieve all devices from our Merak dashboard portal. 

its possible to use the standard web call in PowerBi but we have a limit of 1000 items we can retrieve based on Meraki documentation (https://developer.cisco.com/meraki/api-v1/get-organization-devices/).

With Python, we can bypass this limitation that why I'm trying to use it but I experiencing issue with getting the table in PowerBI.

Regards

[lbendlin]

You can do the same paging in Power Query

Handling paging for Power Query connectors - Power Query | Microsoft Learn

[nabgre]

Hi @lbendlin,

Thanks for providing this ressource. I'll give it a try and update you accordingly.

By any chance, do you know why the Python code isn't generating the table?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

What do you need Python for? Can you do a standard Web call in Power BI?