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.
Does anyone know if it is possible to use multiple datasets while creating a Data Model? Essentially what I am trying to do is make separate building blocks to be used on various reports, but link them only when necessary.
For example, let's say you ran a Dealership/Service Shop
Would it be possible to make a dataset for all the vehicles, purchases, and service records separately and then link the datasets in another data model?
You might want a report on vehicles in inventory, but don't particularly need the service records or purchases in the report. Additionally, another report might want to see the entire model with service records linked to vehicles, linked to vehicle types.
Is this type of modelling possible in Power BI?
Solved! Go to Solution.
Hi @jribs
Yes this is now possible with the new DirectQuery for Power BI Datasets and AAS where you can chain up to 3 datasets.
Here is more information: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | ...
Hi @jribs
Yes this is now possible with the new DirectQuery for Power BI Datasets and AAS where you can chain up to 3 datasets.
Here is more information: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | ...
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.