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.
Hey everyone!
Quick question, what is more efficient for a calendar table?
1. Create it on the fly using DAX
2.Query a calendar table that I have in the service using DirectQuery
3.Create the table using Power Query in the current file
4. Import a Calendar table from the service
FYI:
1.The model currently uses DirectQuery - in other words, I don't need to set up a scheduled refresh. I don't want to switch to a Mixed model unless the performance change is very significant.
2. I need a very simple calendar table (Date, Year, Month, Day)
3. I need this calendar table to create a relationship with the Fact table that is in DirecQuery
Thank you so much
Greetings from Colombia
Alejandro
Solved! Go to Solution.
Hi @aramirez7 ,
Let's use the method of elimination.
First, you don't want to switch to a Mixed model. The defination of Mixed mode:
For any Power BI Desktop file (a .pbix file) that contains some tables from DirectQuery and some import tables, the status bar displays a storage mode called Mixed.
Reference: Set the storage mode
Therefore, your model cannot contain imported tables. Then, methods 1, 3, and 4 do not meet the conditions and only method 2 does.
In addition, you can also consider building a date dimension table directly at the data source and then connect to it using DirectQuery mode, too.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @aramirez7 ,
Let's use the method of elimination.
First, you don't want to switch to a Mixed model. The defination of Mixed mode:
For any Power BI Desktop file (a .pbix file) that contains some tables from DirectQuery and some import tables, the status bar displays a storage mode called Mixed.
Reference: Set the storage mode
Therefore, your model cannot contain imported tables. Then, methods 1, 3, and 4 do not meet the conditions and only method 2 does.
In addition, you can also consider building a date dimension table directly at the data source and then connect to it using DirectQuery mode, too.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
if you already have a date dimensional table with the dates and formats you need would be better to query them in direct query mode from datasource.
Proud to be a Super User!
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 |
---|---|
110 | |
97 | |
81 | |
67 | |
61 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |