Forum Discussion
Power Bi Data Set
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.
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.
Thanks natabird3 for your answer - and how can move a Power Bi Data set in import mode ? Thanks
If you click on the bottom right corner you can see the option to select switch all tables to import mode:
natabird3 sorry, but I can't see this option...do I need to activate something ?
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.