Forum Discussion
Adding tables to existing query/data set/ report in Power BI Online OneLake Hub
I can append tables to Datasets/ Queries on Power BI Desktop. I'm always looking for new stuff to add, so that that is good.
However, I use my Mac online side more that the PC Power BI Desktop whenever possible.
I would like to keep myself mostly on the Mac and use Power BI Online. However, I can not figure out how to edit the query in the report or add tables to the dataset/reports in the OneLake Hub when online. I can see a list of tables, but unlike the Desktop, I see no options for editing tables, adding to existing tables, or adding new tables.
I use multiple reports from one data set, and I would like to keep it that way, so when I choose to add tables, it goes into that single dataset.
Right now, whenever I do this, I download the most recent iteration into OneDrive for Business, overwriting the pbix kept there under the same name, upload it and overwite whatever is most recent in Power BI Online (Mac).
I've got to be missing something more obvious and simple.
1 Reply
- edhans
Community Champion
I'm not sure how to add tables via the online service, but one word of advice. Keep your datasets to one subject matter. Don't add multiple tables about multiple things into one massive dataset. It will eventually become unmanagable. For example, Sales and Accounts Payable usually aren't related in reporting. Your AP team needs to know what was spent, what bills are coming up, but no need to see sales. Same with the sales team. They aren't interested in AP transactions. So keep that data in different datasets. It will make expanding those models easier with relevant data, and will elimininate the possibility of someone seeing data they shouldn't.
