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 all,
In my PBI Desktop I already used the function "Power BI datasets" to retreive a dataset from my app.PowerBI.com service. On my Power BI Desktop I'm trying to add another dataset from Get Data via Odata BUT all my options are Greyed out. I hope this is a quick fix. Thanks
Solved! Go to Solution.
Hi @Anonymous ,
When connecting to dataset on Power BI Service, the connection mode is live connection. Live connection mode doesn't support composite models.
To achieve your requirement, you could enable the DirectQuery for Power BI datasets and Analysis Services feature in preview features.
Also check the considerations and limitations before using this feature.
Best Regards,
Jay
Hi @Anonymous ,
When connecting to dataset on Power BI Service, the connection mode is live connection. Live connection mode doesn't support composite models.
To achieve your requirement, you could enable the DirectQuery for Power BI datasets and Analysis Services feature in preview features.
Also check the considerations and limitations before using this feature.
Best Regards,
Jay
In order to connect to multiple datasets you need to enable the preview of composite models...
File >> Options and Settings >> Options >> Preview Features >> DirectQuery for PBI datasets and AS
If that's not there you need to upgrade your version of power bi desktop.
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 |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |