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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
saudalomairi
Frequent Visitor

Data Ribbon is Greyed out after Adding Shared dataset

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

 

saudalomairi_0-1647500040101.png

 

Thank you

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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. 

vjingzhang_0-1647855999162.png

 

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.

View solution in original post

5 REPLIES 5
v-jingzhang
Community Support
Community Support

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. 

vjingzhang_0-1647855999162.png

 

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.

Where can this feature be found now?

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

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

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 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.

Sept NL Carousel

Fabric Community Update - September 2024

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