cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
omeallynile Frequent Visitor
Frequent Visitor

Importing previous versions of Sharepoint Files into PowerBi

Hey all, 

 

I've been trying to leverage Sharepoint revision history to compare a report we receive daily to historical data. I've written some stuff in REST and managed to isolate URLs for previous versions, and if I open that link in a browser, it indeed gets the old version.

 

However, when I pass that to Web.Contents(), it insists on 'helping' and tries to use GetByServerRelativeUrl('_vti_history/.../file.xlsx')/$value. I get that if was for a current file that would be fine, but for version history it is not. 

 

For the time being, I've tricked it into working by using http instead of https, but does anyone have any idea as to how to get it to work correctly, or is this my only option? 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Importing previous versions of Sharepoint Files into PowerBi

HI @omeallynile ,

Can you please explain more about how to split two versions?  Did you means historical data are based on current file and some filter?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
omeallynile Frequent Visitor
Frequent Visitor

Re: Importing previous versions of Sharepoint Files into PowerBi

Hi @v-shex-msft,

Thanks for responding,

The PiwerBi file references an excel file in SharePoint. That excel file gets emailed to us daily and put into SharePoint using Flow.

We have versioning enabled so when that file is copied in, it overwrites the existing file and saves it as a new version. This means that we can see previous versions at will.

The REST API can return version information for any given file, with a link to that file itself, which looks like 'https://tenant.sharepoint.com/_vti_history/[version]/[path]'.

That file downloads the version it corresponds with. No problem there. This has the historical data because it's an old version of the same file. I'm comfortable with that process. Let me know if I need to rephrase this part.

However, my issue is the way PowerBi handles that path. If I was downloading a regular file over rest, I would use 'https://tenant.sharepoint.com/_api/GetFileByServerRelativeUrl('[path]')/$value'. For previous versions, I can't use this. I have to use the absolute path as referenced above. PowerBi tries to help me by using the server relative portion of the above path - except you can't do that with _vti_history.

So, what I need is for it to basically use the URL I give it, and not try to help me. The only I seem to be able to get this to work is use http instead of https. I'm wondering if there is another way.

Hopefully that makes a little more sense!
Community Support Team
Community Support Team

Re: Importing previous versions of Sharepoint Files into PowerBi

Hi @omeallynile ,

How did you get data from previous file? Maybe you can try to use web connector with 'relativepath' option:

let
    Source = Web.Contents("https://tenant.sharepoint.com", [Headers=[#"key"=mykey], RelativePath="/_api/GetFileByServerRelativeUrl('[path]')/$value"])
in
    Source

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 31 members 817 guests
Please welcome our newest community members: