Reply
nabgre
Frequent Visitor

Issue with python connection

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:

nabgre_1-1711468768703.png

 

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

nabgre_0-1711468172412.png

I'm seeking your support to resolve this matter.

Regards

5 REPLIES 5
nabgre
Frequent Visitor

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

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?

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
Super User
Super User

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)