Forum Discussion
Data Ribbon is Greyed out after Adding Shared dataset
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.
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.
Thank you so much, spent days trying to figure it out!. Lots of appreciations.
Where can this feature be found now?
Hi Anonymous
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 models | Microsoft Power BI Blog
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
