Power Bi Data Set

[Anonymous]

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é

[natabird3]

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]

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

[natabird3]

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

[Anonymous]

@natabird3 sorry, but I can't see this option...do I need to activate something ?

[natabird3]

I think you already converted it as if you see now you can see your table option appear. otherwise, its right here:

But now in the screenshot you sahre you already have the table option if its not the same report then try clicking in the bottom corner.

[Anonymous]

@natabird3  sorry - I took the strong screenshot - here what I get when I use the Power Bi Data set

[Anonymous]

@natabird3 and properties are hidden

[natabird3]

Here is an idea you can vote on but again this is currently not available.

Link: https://ideas.powerbi.com/ideas/idea/?ideaid=d770b60b-8202-4db8-848d-90450923d0bb 

[natabird3 · Accepted solution]

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. 

[natabird3]

the other way to do it is going to the relationship page and changing it from there:

[amitchandak]

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

[Anonymous]

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