Reply
Highlighted
Regular Visitor
Posts: 32
Registered: ‎10-08-2015
Accepted Solution

Accessing a dataset stored in Power BI online via Power BI desktop

[ Edited ]

Hey folks,

This might be an obvious one, but...

 

  • I have an excel file stored in Sharepoint (in a Group that has a Power BI workspace)
  • I have a dataset created from that Excel file in Power BI online.
  • I want to use Power BI desktop to manipulate that dataset first, and create reports from it. 
  • I want the dataset to resfresh automatically. 

 

Is it possible? Until now, I have only used an Enterprise Gateway to access on premises SQL data and I can't figure out what I am missing. 

 

Edit: I should clarify, I can get the dataset to refresh just fine since its built on a a sharepoint excel file, but how can I get to the dataset via Power BI desktop which has more powerful report authoring and query editing options?

 

Thank you,

Jesse

 


Accepted Solutions
Regular Visitor
Posts: 32
Registered: ‎10-08-2015

Re: Accessing a dataset stored in Power BI online via Power BI desktop

I found a potential soloution here: chopping everything off the link after the file name, INCLUDING .xslx, allowed me to get a little futher using the file link via the Get Data/Web interface in Power BI desktop. But then it wont let me authenticate with my organizational account. bear in mind I am the global office 365 admin for my company. I feel closer... but help! 

 

error2.PNG

View solution in original post


All Replies
Regular Visitor
Posts: 32
Registered: ‎10-08-2015

Re: Accessing a dataset stored in Power BI online via Power BI desktop

One thing that looked promising was punching in the web path of the Sharepoint file (in Power BI desktop, Get Data/Web), but that genrates the following error:

 

Capture.PNG

Regular Visitor
Posts: 32
Registered: ‎10-08-2015

Re: Accessing a dataset stored in Power BI online via Power BI desktop

I found a potential soloution here: chopping everything off the link after the file name, INCLUDING .xslx, allowed me to get a little futher using the file link via the Get Data/Web interface in Power BI desktop. But then it wont let me authenticate with my organizational account. bear in mind I am the global office 365 admin for my company. I feel closer... but help! 

 

error2.PNG

Regular Visitor
Posts: 32
Registered: ‎10-08-2015

Re: Accessing a dataset stored in Power BI online via Power BI desktop

Embarrased to admit I sorted it out, but getting the sharepoint file path link via excel, and deleteing everything >= the ? worked. For whatever reason the authetication error dissapeared this go around. 

 

Shout out to Matt Allington for the helpful blog post I found in another thread. 

 

Best,