Forum Discussion

joarobert's avatar
joarobert
Frequent Visitor
4 years ago
Solved

Composite Models: How to apply changes in the DirectQuery-connected dataset?

Hi,  With composite models, you have to change a dataset to Direct Query, which can then be connected to other imported data sources.  This all works fine for us.  However, consider the case...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi joarobert ,

     

    First make sure that you have checked the features DirectQuery for PBI datasets and AS. in the image below in Power BI desktop.

     

    After published the report,

    Step 1: Go to Settings -> Datasets. Select the dataset that needs to be scheduled.

     

    Step 2: On-Promise sources (both import and direct query mode), you need to configure the On-Premise gateway and add a connection for each data source. Enable the applicable Gateway for your dataset,

     

    Step 3: At first publishing of the report, you need to provide data source credentials with details such as authorization method, privacy level.

     

    Step 4: Go to Scheduled refresh. Enable the Schedule refresh option and create schedules as per your requirement.

     

    Please do make sure that your gateway and data source is up on running during the refresh. With the above steps, you can easily schedule refreshes for your reports that use a composite model. 

     

    For more information,please refer to:Power BI Tips: Schedule Refresh on Composite Models 

     

    Hope it helps,


    Community Support Team _ Caitlyn

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

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi joarobert ,

 

First make sure that you have checked the features DirectQuery for PBI datasets and AS. in the image below in Power BI desktop.

 

After published the report,

Step 1: Go to Settings -> Datasets. Select the dataset that needs to be scheduled.

 

Step 2: On-Promise sources (both import and direct query mode), you need to configure the On-Premise gateway and add a connection for each data source. Enable the applicable Gateway for your dataset,

 

Step 3: At first publishing of the report, you need to provide data source credentials with details such as authorization method, privacy level.

 

Step 4: Go to Scheduled refresh. Enable the Schedule refresh option and create schedules as per your requirement.

 

Please do make sure that your gateway and data source is up on running during the refresh. With the above steps, you can easily schedule refreshes for your reports that use a composite model. 

 

For more information,please refer to:Power BI Tips: Schedule Refresh on Composite Models 

 

Hope it helps,


Community Support Team _ Caitlyn

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

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello, 

     

    I have done all these steps but still it is not working. 

    To recap I have 2 Dataset A1 and A2 both connected to a sql server with a gateway properly setted. 

    I have then a composite Dataset B connected in Direct Query to A1 and A2 ( no need of gateways then)

    I do then :

    1. Make some changes on desktop on Dataset A1 (ex: adding a measure)

    2. Publish the new Dataset  A1 with the same name.

    3. Refresh Composite Dataset B directly on Web Service

    4. I cannot see the changes on Dataset B

     

    I need to re download B on desktop, update on desktop and then republish. 

     

    Is there a way to avoid that ? 

     

    Thanks a lot in advance, 

     

    Cyprien