Schedule Refresh ON single table in dashboard using PBI Dataset

[bhaskarpbi999]

Hi Team,

I have a excel sheet Access RLS stored in sharepoint folder  which we are using as a row level security table In dashboard.

Can we refresh this table from PBI service on daily basis using PBI dataset, If yes let me know the pre-requisites to implement it.

Folder screeenshot

Dashboard screenshot

Regards,

Bhaskar

[bhaskarpbi999]

Hi Jienpeng,

Thanks for the solution and many thanks for your support which really help's me to focus on my issue.

Regards,

Bhaskar

[bhaskarpbi999]

Hi Jienpeng,

Thanks for the solution and many thanks for your support which really help's me to focus on my issue.

Regards,

Bhaskar

[christinepayton]

Yes, you can refresh SharePoint sources on a schedule. You just need to go into the semantic model settings and give it your credentials (the link will say "edit credentials" and then schedule like any other source. 

[bhaskarpbi999]

Hi Christine,

Thanks for the reply.

Regards,

Bhaskar

[amitchandak]

@bhaskarpbi999 , Open the setting of the dataset, do you see that in the connection setting along with refresh settings enabled?

[bhaskarpbi999]

Hi Amit,

Thanks for the update.

Do we need to have Power BI premium license for scheduling refresh on a dataset or Shared capacity.

Could you please let me know thanks for your supporrt.

Regards,

Bhaskar

[Anonymous · Accepted solution]

Hi, @bhaskarpbi999 

Thanks @christinepayton and @amitchandak . Different licenses have a limit on the number of refreshes. For shared capacity, there is a limit of 8 refreshes per model per day. If the semantic model resides on a Premium capacity, you can schedule up to 48 refreshes per day in the semantic model settings. 

Data refresh in Power BI - Power BI | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft Learn

The free license does not allow you to enter or create shared workspaces. The free license allows you to configure scheduled refresh for the My workspace semantic model. If you need to configure a scheduled refresh for the semantic model above for shared capacity, you must have at least a Pro or PPU license.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bhaskarpbi999]

Hi Jienpeng,

Thanks for the solution and many thanks for your support which really help's me to focus on my issue.

Regards,

Bhaskar