Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Bi Data Set

Dear Power Bi Communitee,

I use a Power Bi Dataset in order to build some visuals. But I would need to visualize & add some tables. Unfortunately, it's not possible -> I can't see the icon data on the left part. Do you have any explanations? This appears even if I'm the owner of the data set.

Thanks for your help.

Hervé

  • Indeed they are, apologies i misunderstood your problem, as this is not direct query to a dataset its live connection. So when its live you are not able to change it. However, you said this is your data source why dont you connect to the table or SQL instead of the dataset, it would be possible to make the necessary changes then. If you connected to the dataset directly you cannot change it unfortunately. 

12 Replies

  • Anonymous , As of now you can add anything else, if you are using power bi dataset

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello - sorry I didn't get your point. Can't add any table to my PB Data Set from PB Desktop.

  • natabird3's avatar
    natabird3
    Skilled Sharer

    The reason why you dont see the option is because you are using direct query mode and not import. If you change all your tables to be import mode you will see the option and be able to make changes to the data in the tables. The difference is that if you use direct query you will not need to refresh the report to get the new data, but if its import mode everytime before you want to see the new data you need to refresh and re-publish the report (just an additional step). Hope this helps. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks natabird3 for your answer - and how can move a Power Bi Data set in import mode ? Thanks

      • natabird3's avatar
        natabird3
        Skilled Sharer

        If you click on the bottom right corner you can see the option to select switch all tables to import mode: