cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BBIUser Member
Member

Version Control Using SharePoint-Error while opening .pbix in Power BI Desktop from File Explorer

I was not sure in which forum I should post this question, but I took a call to do it here.

 

I read few articles that 'version control' of all the .pbix/.pbit files can be done using SharePoint or One Drive. But I could not find the workflow on how to do it from end to end.

 

These are steps I followed to open the 'Checked Out' .pbix file from File Explorer.

Step1: Created a .pbix file in Power BI Desktop.

Step2: Uploaded the new .pbix file to the SharePoint (Site) which will be in a company's network location.

Step3: Check out the .pbix file in SharePoint (Site).

Step4: Navigate to the 'File Explorer' (Network location) to open the .pbix file in a Power BI Desktop.

 

After the 4th step I am getting this error.

3.png

 

I have several questions since we have "NEW WORKSPACES PREVIEW" now.

1) How to open the checked out .pbix file in Power BI Desktop? 

    Do I need to download .pbix file manually from SharePoint Site even though I check out the file and then open the file in Power BI Desktop?

2) 'Get Data' from Power BI Desktop connects to the SharePoint folder but how do I get the actual datasource fields?

3) Related to "NEW WORKSPACES PREVIEW":

'Get Data' > 'Get Files' from Power BI Service connects  to the SharePoint - Team Site. I can connect and open the report and dataset in Power BI Service.

But if I want it again to use it as Power BI Desktop file, do I need to download the .pbix file from Power BI Service and then update the dataset or report?

 

I thought there is direct check in - check out process because of the integration between Power BI and SharePoint (or OneDrive) 

I am having hard time to digest and understand how the version control works with SharePoint and One Drive. Am I missing any steps here with the latest version updates.

 

Any help is appreciated. 

Is there any guide or article where this workflow is explained or tells how the version control works with the latest version update?

 

Thanks!

5 REPLIES 5
v-danhe-msft Super Contributor
Super Contributor

Re: Version Control Using SharePoint-Error while opening .pbix in Power BI Desktop from File Explore

Hi @BBIUser,

I have asked the Product Group for more details, I will post the information once I get any updates. And I suggest you could just download the pbix file manually from SharePoint Site and then open the file in Power BI Desktop.

 

Regards,

Daniel He

 

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

Re: Version Control Using SharePoint-Error while opening .pbix in Power BI Desktop from File Explore

Thanks @v-danhe-msft Daniel He. 

I will wait for your post. Appreciate it!

v-danhe-msft Super Contributor
Super Contributor

Re: Version Control Using SharePoint-Error while opening .pbix in Power BI Desktop from File Explore

Hi @BBIUser,

The Product Group have replied me that now Power BI could not support the feature to open the pbix file in Power BI Desktop from the SharePoint. 

Hope the message could help you.

 

Regards,

Daniel HE

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft Super Contributor
Super Contributor

Re: Version Control Using SharePoint-Error while opening .pbix in Power BI Desktop from File Explore

Hi @BBIUser,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

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

Re: Version Control Using SharePoint-Error while opening .pbix in Power BI Desktop from File Explore

Hi @v-danhe-msft.

 

I am doing it manually until Microsoft provides solution for version control. Is there anything in development pipleline?

Is there are any other alternate that we can use for Power BI Version control? Something like VSTS.

 

Thanks!

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and 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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 448 members 4,883 guests
Please welcome our newest community members: