The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to 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/
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/
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!
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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
231 | |
127 | |
117 | |
82 | |
82 |