Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Juramirez
Resolver I
Resolver I

Create multiple dataset regarding customers ID

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

 

2 ACCEPTED SOLUTIONS
Eric_Zhang
Microsoft Employee
Microsoft Employee


@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

 


@Juramirez

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).

View solution in original post

Thanks @Eric_Zhang

 

Solved it creating multiple reports from one data source and publishing them to different App Workspaces.

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft Employee


@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

 


@Juramirez

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors