Data Ribbon is Greyed out after Adding Shared dataset

[saudalomairi]

Dear Community,

After adding Power Bi Datasets I could see that the Data Ribbon is Greyed out, not sure why! is there any particular reason to that behavior 

Though this video shows it’s not suppose to https://www.youtube.com/watch?v=ZSyYegfA6PQ

Thank you

[v-jingzhang · Accepted solution]

Hi @saudalomairi 

You need to check the following highlighted preview feature from File > Options and settings > Options > Preview features > DirectQuery for PBI datasets and AS and restart your Power BI Desktop application. After that, the Data Ribbon will be activated. 

It is because Power BI dataset is supported in Live Connection mode by default. To use it along with other data sources, you need to turn on this preview feature. Then the behavior will be the same as in the video. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[levi123]

Where can this feature be found now?

[v-jingzhang]

Hi @levi123 

This preview has ended and the feature was officially released. Please refer to the announcement blog post: Announcing general availability for composite models on Power BI Datasets and Analysis Services mode...

To simplify the name of the feature, starting today we will refer to models built using this feature as composite models. We will drop the name “DirectQuery for Power BI Datasets and Analysis Services.” That name served its purpose during the preview period to be able to clearly identify that this was a preview feature. However, you are making a composite model on top of sources, which happen to include these “special” sources, such as Power BI Datasets.

More reference:

Use composite models in Power BI Desktop - Power BI

Composite model guidance in Power BI Desktop - Power BI

Best regards,

Jing

[saudalomairi]

Thank you so much, spent days trying to figure it out!. Lots of appreciations. 

[amitchandak]

@saudalomairi , With power bi dataset live connection, you are not allowed to add new sources columns etc

You can create direct connection - that require few permission too

https://radacad.com/directquery-for-power-bi-dataset-how-does-it-work

Live connection

https://radacad.com/live-connection-when-power-bi-comes-hybrid

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets