cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User I
Super User I

Ways to refresh file on sharepoint without pro account

Is there any way to have a report built in desktop have a dataset refreshed from a file in sharepoint without having pro features? The only way I've found is to connect to an excel file from the power bi app online, but I don't want to make my reports again (also, how do you add measures in this?).

 

It says that the free version can have a scheduled refresh up to once a day, but I'm very confused on what data this is. My data is not using a gateway. I can move it to another location or service - is there any way this can be done?

 

Thank you,

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Ways to refresh file on sharepoint without pro account

Hi @SteveCampbell,

 

1. Is there any way to have a report built in desktop have a dataset refreshed from a file in sharepoint without having pro features? The only way I've found is to connect to an excel file from the power bi app online, but I don't want to make my reports again (also, how do you add measures in this?).

 

Based on my test, to retrieve data from a Excel file which stores in SharePoint online site in Power BI desktop, we can follow the steps in this article to use web data source: Use OneDrive for Business links in Power BI Desktop. To create measures in desktop, you can refer to this article: Tutorial: Create your own measures in Power BI Desktop .

 

As the SharePoint online doesn't require gateways, we can publish the report to workspace which uses Power BI free account.

 

2. It says that the free version can have a scheduled refresh up to once a day, but I'm very confused on what data this is. My data is not using a gateway. I can move it to another location or service - is there any way this can be done?

 

The supported data sources to use schedule refresh list in this article: What’s supported? . As you are using free account, you need to know which are pro content, see: Power BI Pro content - what is it?. So in your environment, except the data sources which are pro features, other data sources should support schedule refresh daily or weekly.

 

By the way, you can also try the Power Bi Pro trail follow this article to experience pro features: Power BI Pro 60 day trial.

 

Best Regards,
Qiuyun Yu

 

 

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

View solution in original post

2 REPLIES 2
BhaveshPatel Super Contributor
Super Contributor

Re: Ways to refresh file on sharepoint without pro account

You can check third party product "Power Update". It is free for a single file and very good solution without any refresh limits.

Check out at here: https://www.powerpivotpro.com/2015/02/introducing-power-update/

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Moderator v-qiuyu-msft
Moderator

Re: Ways to refresh file on sharepoint without pro account

Hi @SteveCampbell,

 

1. Is there any way to have a report built in desktop have a dataset refreshed from a file in sharepoint without having pro features? The only way I've found is to connect to an excel file from the power bi app online, but I don't want to make my reports again (also, how do you add measures in this?).

 

Based on my test, to retrieve data from a Excel file which stores in SharePoint online site in Power BI desktop, we can follow the steps in this article to use web data source: Use OneDrive for Business links in Power BI Desktop. To create measures in desktop, you can refer to this article: Tutorial: Create your own measures in Power BI Desktop .

 

As the SharePoint online doesn't require gateways, we can publish the report to workspace which uses Power BI free account.

 

2. It says that the free version can have a scheduled refresh up to once a day, but I'm very confused on what data this is. My data is not using a gateway. I can move it to another location or service - is there any way this can be done?

 

The supported data sources to use schedule refresh list in this article: What’s supported? . As you are using free account, you need to know which are pro content, see: Power BI Pro content - what is it?. So in your environment, except the data sources which are pro features, other data sources should support schedule refresh daily or weekly.

 

By the way, you can also try the Power Bi Pro trail follow this article to experience pro features: Power BI Pro 60 day trial.

 

Best Regards,
Qiuyun Yu

 

 

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

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors