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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
jeongkim
Post Prodigy
Post Prodigy

Query with api version?

Hi,

 

What is that api version? is that related to Transfrom sample file?

 

jeongkim_0-1742886230447.png

 

1 ACCEPTED SOLUTION

Hello Jeongkim,

Power BI automatically selects the appropriate API version for those connections.

Your SharePoint environment supports backward compatibility, so explicitly defining the API version isn’t always necessary.

If removing it causes errors, keep it to ensure compatibility.

If it's causing issues and your other reports work fine without it, try removing only the , [ApiVersion = 15] and check if the query still functions correctly.

 

If I ansered your query , kindly accept the solution 

 

Thanks

Pankaj

View solution in original post

3 REPLIES 3
pankajnamekar25
Super User
Super User

The ApiVersion = 15 in your Power Query M code refers to the SharePoint API version used when retrieving data via SharePoint.Contents().
This version is commonly used when connecting to SharePoint Online or SharePoint 2013+

I see, should I keep that text? 
It seems getting error if I delete ", [ApiVersion = 15]"

 

But my other PBI dont' have api version and working well..

Hello Jeongkim,

Power BI automatically selects the appropriate API version for those connections.

Your SharePoint environment supports backward compatibility, so explicitly defining the API version isn’t always necessary.

If removing it causes errors, keep it to ensure compatibility.

If it's causing issues and your other reports work fine without it, try removing only the , [ApiVersion = 15] and check if the query still functions correctly.

 

If I ansered your query , kindly accept the solution 

 

Thanks

Pankaj

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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