Loading new data after chosing a previous BI dataset

[jmvidal]

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.

[v-eachen-msft · Accepted solution]

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/

https://docs.microsoft.com/en-us/power-bi/refresh-data#live-connections-and-directquery-to-on-premis...

https://community.powerbi.com/t5/Community-Blog/Power-BI-Live-connection-vs-Import-comparison-and-li...

[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!

[Greg_Deckler]

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.

[jmvidal]

Thanks @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.