Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI Datasets missing in Excel

Hi all,   I'm trying to connect an Excel file to a Power BI dataset. I managed to do that in the past. However, when I try it, there are only 6 datasets accessible via Excel even though there a...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    If you cannot find a dataset (semantic model) from Excel, try visiting Power BI Service with your account and use Analyze in Excel feature to live connect to the same dataset. This can be an alternative very often. Ensure that you still have Build permission to the Power BI semantic model or have at least a Contributor role in the Power BI workspace containing your semantic model.

    Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

 

If you cannot find a dataset (semantic model) from Excel, try visiting Power BI Service with your account and use Analyze in Excel feature to live connect to the same dataset. This can be an alternative very often. Ensure that you still have Build permission to the Power BI semantic model or have at least a Contributor role in the Power BI workspace containing your semantic model.

Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!