Forum Discussion
Helper IILoading new data after chosing a previous BI dataset
Hi,
I just realized that after creating a new pbix and choosing to use a previous BI dataset, you cannot add any more data from the new file.
Isn't there any way to create a new dataset based on the original with new sources?
Thank you.
Hi jmvidal ,
This is a live connection mode, so you couldn't add new data directly. As shown in the screenshot, you can't open query editor.
Here are differences between live connection and other modes.
https://guyinacube.com/2019/04/18/power-bi-get-data-import-vs-directquery-vs-live/
4 Replies
- Greg_Deckler
Community Champion
So you went into Desktop and chose Get data and then chose Power BI Dataset? Is that correct? If so, this is a live connection to the dataset in the Service. When that dataset refreshes, you will have the new data automagically.
jmvidalThanks Greg_Deckler , but I'm trying to add new data, like an Excel, or data from new databases.
Descktop just allows me to work in report mode, not in data or model,
Thank you.
- v-eachen-msft
Community Support
Hi jmvidal ,
This is a live connection mode, so you couldn't add new data directly. As shown in the screenshot, you can't open query editor.
Here are differences between live connection and other modes.
https://guyinacube.com/2019/04/18/power-bi-get-data-import-vs-directquery-vs-live/
- jmvidal
Understood.
My idea was to build a corporate dataset so users could use to build their own visualizations, being able to add other sources of data.
Now I see this is not possible.
Thank you!
