Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Manikanta2108
Frequent Visitor

We are having Cloud Prisma Team. What is required from them to fetch the data in powerbi

 
6 REPLIES 6
Manikanta2108
Frequent Visitor

Prisma Team provided me Access ID, Secret Key and API Base URL. How can i integrate Power BI to Cloud Prisma 

Hi @Manikanta2108 

Thank you for reaching out to the Microsoft Fabric Forum Community.

Yes, you can connect Power BI with Prisma Cloud using the Access ID, Secret Key, and API Base URL. The process starts with an API call to log in using your Access ID and Secret Key, which gives you a JWT token. You then use that token in another API call to pull the data you need—like alerts, compliance reports, and more.

Both of these API calls can be set up right inside Power BI using Power Query’s Web.Contents function. Once the data comes in as JSON, you can shape and visualize it just like any other dataset in Power BI.

If this information is helpful, please “Accept as solution”  to assist other community members in resolving similar issues more efficiently.
Thank you.

How can i do API call login to get JWT in PowerBI. They provide me https://app.prismacloud.io/ this base URL and Access ID and Secret Key

pankajnamekar25
Memorable Member
Memorable Member

Hello @Manikanta2108 

To enable Power BI to fetch data from the Cloud Prisma team, they need to provide the data source connection details such as the server or endpoint URL, database or schema name, and any required credentials like usernames, passwords, or tokens. The authentication method should be clarified—whether it's SQL authentication, Azure Active Directory, OAuth, or service principal.

If the data source is on-premises, they must configure an on-premises data gateway and ensure Power BI can access it. For cloud-hosted data, firewall rules or network access may need to be adjusted to allow Power BI to connect.

In addition, they should share the data schema or API documentation, including available tables, fields, relationships, and any required query formats or endpoints. Access permissions should be verified to ensure your Power BI user has the necessary rights to read the data.

 

 

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Hi @Manikanta2108 

I hope the information shared by @pankajnamekar25 helpful to you. If your question has been answered, kindly mark the most relevant reply as the Accepted Solution. This small action can make a big difference for others who are looking for the same solution.
@pankajnamekar25 thank you so much for your inputs.

Hi @Manikanta2108 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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