cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Connection to OneDrive from Online

 

Hello!

Why do I see a blank page when trying to get data from OneDrive from the PowerBI online most of the time?

I once (with no reason) managed to see my real list of files and folders and tried to connect to a file, it succeded but then I wasn't able to download the report in .pbix to edit it, why?

Is it possible to connect to a folder of csv on drive automatically refreshing at files changing? I read this phrase on BI online documentation:

"OneDrive - Business – If you have OneDrive for Business and you sign into it with the same account you sign into Power BI with, this is by-far the most effective way to keep your work in Excel Power BI Desktop, or a .CSV file and your dataset, reports, and dashboards in Power BI in-sync. Because both Power BI and OneDrive are in the cloud, Power BI connects to your file on OneDrive about every hour. If any changes are found, your dataset, reports, and dashboards are automatically updated in Power BI."

 

 

Cattura.JPG

 

Thanks!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Supplier
Solution Supplier

Re: Connection to OneDrive from Online

@AGo 

If you are trying to connect to a single file that is indeed the way to go. (And should work perfectly fine, might have something to do with your rights)

However if you are trying to load all files from a folder that can only be achieved by using the (Sharepoint)folder connector.

And because it needs to transform the data thats not a thing that happens live.

 

 

 

View solution in original post

3 REPLIES 3
Highlighted
Solution Supplier
Solution Supplier

Re: Connection to OneDrive from Online

Hello @AGo,

You can use the sharepoint folder connector to connect to your one drive folder.

When you login to your onedrive online you can copy the directory and use this as the source.

After that you login to "Organisational account" the data will be available.

 

Kind regards
Joren Venema

Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily. 

Highlighted
Helper V
Helper V

Re: Connection to OneDrive from Online

Thanks but I yet managed to do this, the problem is that the refresh has to be manual or scheduled at a specific time, and it refreshes all the csvs, not only the modified or new ones.

I think we have to use a OneDrive connection method, the Sharepoint folder one seems different from what said in the lastphrase of next paragraph:

"OneDrive - Business – If you have OneDrive for Business and you sign into it with the same account you sign into Power BI with, this is by-far the most effective way to keep your work in Excel Power BI Desktop, or a .CSV file and your dataset, reports, and dashboards in Power BI in-sync. Because both Power BI and OneDrive are in the cloud, Power BI connects to your file on OneDrive about every hour. If any changes are found, your dataset, reports, and dashboards are automatically updated in Power BI."

 

Thanks

Highlighted
Solution Supplier
Solution Supplier

Re: Connection to OneDrive from Online

@AGo 

If you are trying to connect to a single file that is indeed the way to go. (And should work perfectly fine, might have something to do with your rights)

However if you are trying to load all files from a folder that can only be achieved by using the (Sharepoint)folder connector.

And because it needs to transform the data thats not a thing that happens live.

 

 

 

View solution in original post

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors