Forum Discussion

PakAli's avatar
PakAli
Frequent Visitor
1 year ago
Solved

Excel data connector to access powerbi dataset

Hi

I am not really sure if the question shall be asked here or in Excel forum
but , it is related to PowerBI & PowerQuery

All this while, PowerQuery access excel files for data source

However, I just found out that excel dan acees PowerBI dataset

Unfortunately, I wonder what is the setting required
coz I can only see 2 of my datasets, while the rest is not visible in the excel

Hopw someone can give guidance
been searching around, but no info

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi PakAli ,

    Thanks for lbendlin's reply!

    And PakAli , during my own testing I realized that the semantic model displayed here is not complete and some of it is missing, probably due to caching. You may need to manually enter the name of the semantic model you want to link to in the search bar to display it properly.


    But if you still can't find the semantic model you need by searching for it, then first of all, as lbendlin said, you have correctly configured the connection and verified the credentials for these semantic models. At the same time, it is also possible that you lack certain permissions, for example, the semantic model uses some kind of sensitivity tags that you do not have the right to view, or you do not have enough permissions to a certain workspace, and so on. The specific limitations of the official document you can check to find out for yourself:
    Connect Excel to Power BI semantic models - Power BI | Microsoft Learn

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Currently you need "Build"  access to these semantic models.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PakAli ,

    Thanks for lbendlin's reply!

    And PakAli , during my own testing I realized that the semantic model displayed here is not complete and some of it is missing, probably due to caching. You may need to manually enter the name of the semantic model you want to link to in the search bar to display it properly.


    But if you still can't find the semantic model you need by searching for it, then first of all, as lbendlin said, you have correctly configured the connection and verified the credentials for these semantic models. At the same time, it is also possible that you lack certain permissions, for example, the semantic model uses some kind of sensitivity tags that you do not have the right to view, or you do not have enough permissions to a certain workspace, and so on. The specific limitations of the official document you can check to find out for yourself:
    Connect Excel to Power BI semantic models - Power BI | Microsoft Learn

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.