Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all
I'm wondering if is possible to create multiple datasets regarding one datasource and when I refresh them via Power BI API, it takes each one as one separated regardless if they comes from the same DataSource. I mean, something like this:
I have 3 Customers: A, B and C (each one with a unique identifier).
All of them are in the same app and their info comes from the same DataSource.
What I want to do is to create one dataset to each Customer and this way I have 8 refreshes per day per DataSet (24 refreshes for one single DataSource).
This mean that when I publish them to my workspace, i must see 3 datasets (it depends of how many customers I have in my report) in my workspace instead one.
Is this possible?
Regards
Solved! Go to Solution.
@Juramirez wrote:
Hi all
I'm wondering if is possible to create multiple datasets regarding one datasource and when I refresh them via Power BI API, it takes each one as one separated regardless if they comes from the same DataSource. I mean, something like this:
I have 3 Customers: A, B and C (each one with a unique identifier).
All of them are in the same app and their info comes from the same DataSource.
What I want to do is to create one dataset to each Customer and this way I have 8 refreshes per day per DataSet (24 refreshes for one single DataSource).This mean that when I publish them to my workspace, i must see 3 datasets (it depends of how many customers I have in my report) in my workspace instead one.
Is this possible?
Regards
8 refreshes per day is a limitation on a dataset, regardless of the datasource. You can create different reports for individual users, even though the datasource are the same.
By the way, to lift the 8 times limitation, you can either use DirectQuery mode or purchase Power BI Premium license(48 times refreshes per day).
Thanks @Eric_Zhang.
Solved it creating multiple reports from one data source and publishing them to different App Workspaces.
@Juramirez wrote:
Hi all
I'm wondering if is possible to create multiple datasets regarding one datasource and when I refresh them via Power BI API, it takes each one as one separated regardless if they comes from the same DataSource. I mean, something like this:
I have 3 Customers: A, B and C (each one with a unique identifier).
All of them are in the same app and their info comes from the same DataSource.
What I want to do is to create one dataset to each Customer and this way I have 8 refreshes per day per DataSet (24 refreshes for one single DataSource).This mean that when I publish them to my workspace, i must see 3 datasets (it depends of how many customers I have in my report) in my workspace instead one.
Is this possible?
Regards
8 refreshes per day is a limitation on a dataset, regardless of the datasource. You can create different reports for individual users, even though the datasource are the same.
By the way, to lift the 8 times limitation, you can either use DirectQuery mode or purchase Power BI Premium license(48 times refreshes per day).
Thanks @Eric_Zhang.
Solved it creating multiple reports from one data source and publishing them to different App Workspaces.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
4 | |
3 | |
3 | |
2 | |
2 |