Questions about Composite Models

[farhandsome]

Hi all,

I have just read up on the new feature for Power BI: composite modelling.

https://docs.microsoft.com/en-us/power-bi/desktop-composite-models

Very excited about this feature as we have a multitude of data sources: some on our SQL server which I'd like to connect via DirectQuery and some imported from Excel OneDrive. 

However, I had a couple questions about this new mixed storage mode options:

1. Will I need to update to the newest version of PBI to use composite modelling?
2. This is my main question: it involves the data refresh. Will I be able to utilize the DirectQuery refresh for those sources while the import sources use the normal scheduled refresh?

Please let me know!

Thanks,

Farhan

[v-yuta-msft · Accepted solution]

@farhandsome ,

For question1, yes, you'd better to use the latest version of power.

For question2, if the "DirectQuery refresh" means cache refresh, I would suggest that you can't configure schedule refresh. You need to convert direct query mode to import mode.

About data refresh in power bi, I would suggest you read doc below:

https://docs.microsoft.com/en-us/power-bi/refresh-data

Community Support Team _ Jimmy Tao

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

[amitchandak]

Did not get completed.

I think this came post sep-2019 release.

Also refer :https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fas...