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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Anonymous
Not applicable

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+

Anonymous
Not applicable

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
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.