Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
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.
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.
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.
@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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.