How to setup monthly refresh for PowerBI ?
- Using PowerBI API and ADF
- Using Logic Apps and ADF
The blog includes article on Datawarehousing, Business Intelligence, SQL Server, PowerBI, Python, BigData, Spark, Databricks, DataScience, .Net etc.
Below is the sales table
Order_Date |
Name |
Product |
SubCategory |
Category |
Quantity |
SalesAmount |
DiscountAmount |
10-08-2011 |
Megan Stewart |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
14-09-2011 |
Elizabeth Clark |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
14-10-2011 |
Olivia Torres |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
20-10-2011 |
Ethan Foster |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
14-11-2011 |
Beth Gutierrez |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
14-11-2011 |
Dawn Wu |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
20-12-2011 |
Desiree Dominguez |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
22-12-2011 |
Kevin Wright |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
17-01-2011 |
Clarence Rai |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
23-01-2011 |
Elizabeth Johnson |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
03-02-2011 |
Jaclyn Lu |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
19-03-2011 |
Jon Zhou |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
04-04-2011 |
Arthur Carlson |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
07-04-2011 |
Adam Ross |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
17-04-2011 |
Carolyn Navarro |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
29-04-2011 |
Abby Sai |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
05-05-2011 |
Ross Jordan |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
06-05-2011 |
April Deng |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
02-06-2011 |
Ebony Gutierrez |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
08-06-2011 |
Julian Ross |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
How to setup monthly refresh for PowerBI ? PowerBI generally allows daily or weekly refreshes with options of selecting multiple time values...