Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I want to get data from a Power BI app and use it in another Power BI dashboard.
How can I do that?
Thanks!
Solved! Go to Solution.
Hi @UsePowerBI ,
When connect to Power BI dataset, you are using Live Connection. And when using Live Connection, you can't use other connect mode like Import or Direct Query to connect other data source.
In your scenario, you are using Import or DQ to connect other source, so you can't connect to Power BI dataset with Live Connection at the same time.
Currently you can't use other connect mode when connecting to Power BI dataset. As a workaround you may use Down Load Pbix feature in Power BI Service, so that you can connect to other data source in the downloaded dataset.
Best Regards,
Jay
Hi @UsePowerBI ,
What is the error detail? Is it something like:
"The connect live option for this file is disabled because it already contains data from another data source. You cannot explore live data and connect to another typ...."
If so, the problem is that you could not use Import and Live Connection in one report at the same time.
If not, please show more details.
Best Regards,
Jay
@v-jayw-msft yes, that is the error
How do I make all connections non-live and how do I connect to the PowerBI dataset with a non-live connection? I cannot find the option to choose.
Thanks
Hi @UsePowerBI ,
When connect to Power BI dataset, you are using Live Connection. And when using Live Connection, you can't use other connect mode like Import or Direct Query to connect other data source.
In your scenario, you are using Import or DQ to connect other source, so you can't connect to Power BI dataset with Live Connection at the same time.
Currently you can't use other connect mode when connecting to Power BI dataset. As a workaround you may use Down Load Pbix feature in Power BI Service, so that you can connect to other data source in the downloaded dataset.
Best Regards,
Jay
You can use data from published Power Bi datasets (needs to be shared with you)
@Greg_Deckler @Anonymous
Thanks but I get the error of "The connect live option for this file is disabled...".
I click to enable Power BI Service Live Connection but it is not available in the Options:
Any idea?
@UsePowerBI - Use Get data -> Power BI datasets
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |