Any tips on migrating .pbix files to SharePoint?

[BIanon]

Hello Community,

I am currently migrating a bunch of datasets to SharePoint and am wondering what the best wayto do it is. Currently, the way I've done it is by:

1. Download .PBIX file from PBI Service

2. Upload to SharePoint
3. Upload to Service from SharePoint

4. This creates a duplicate of my current model since SP doesn't overwrite

5. I change which dataset the App is pointing to

6. Delete old model not hosted in SP

This works fine but I wouldn't be surprised if someone out there has a better way?

[ibarrau]

Hi. What a request. This is new haha. I think it might be reaaaaally tricky but not imposible. If your reports/datasets size are lower than 1gb, then you can use the Power Bi Rest API for downloading.

I think using Power Bi and Sharepoint API you could create the steps with a script.

1- Export pbix file from Service to local machine or keep it in memory with API

2- Upload it to sharepoint with API

3- Get it from sharepoint and import at service (this is the only step I'm not sure that will result in the same way as browsing sharepoint from the UI)

4- If the duplicate is create delete dataset with API

5- Update datasources of dataset (complex step)

6- I guess you have deleted this one on step 4

If step 3 can't be done you can split the script in two. That should help a while.

I hope that helps,

[BIanon]

Thank you for your reply.

I am getting slightly worried by your reaction I have to admit - is it a bad idea to host the pbix files in SP?

It seems to offer some basic features like centralizing datasets, check in/out, basic version history and avoiding locking a pc down while waiting for a file to publish.
Am I missing some obvious and better way of handling this?

I will look into setting up a script for it, thank you

[ibarrau · Accepted solution]

No take this the wrong way, storing at sharepoint is a great idea for keeping a version history of your developments. The only step that might be weird is the importing from sharepoint that duplicate developments. When a developer uses the pbix can publish the work and upload to sharepoint.

That way it keeps the versioning and the dataset at Service.

I hope that helps,