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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

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.