Forum Discussion
Helper IIIBasic question about properly planning reports and Data Refresh - how it is done in the industry
Hi arunbyc , thank you for reaching out to the Microsoft Fabric Community Forum.
There are several courses in youtube one can learn from. Below are the links to the videos and Microsoft Learn Documentation that i recommend. :
You can find Microsoft doucumentation on almost everything PowerBI here:
1. https://learn.microsoft.com/en-us/power-bi/?wt.mc_id=powerbi_inproduct_settings
2. https://learn.microsoft.com/en-us/training/powerplatform/power-bi
For Individual Courses try these:
1. Learn Power BI: Tutorial for Beginners -Full Cours... - Microsoft Fabric Community
2. https://www.youtube.com/watch?v=cyWVzAQF9YU
3. https://www.youtube.com/watch?v=xDgyDXyu6FQ
4. https://www.youtube.com/watch?v=ENZm_7jWU4Q
5. https://www.youtube.com/watch?v=MII8NIF98RM
6. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
7. https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
8. https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-manage
9. https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install
10. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Community SupportHi arunbyc , thank you for reaching out to the Microsoft Fabric Community Forum.
Anonymous , Martin_D have explained it correctly.
- Creating one comprehensive semantic model (or shared dataset) that includes all the necessary tables and columns for your reports is a smart move. This reduces the number of refreshes and the load on your database. Each report can then use the subsets of the data as needed. This also enhances consistency and manageability and leads to better performance and faster query responses, especially if the queries hit the cached data. A single model uses less RAM on the backend server, avoiding potential performance bottlenecks caused by swapping models in and out of memory.
- With a Power BI Pro license, you don't need any extra subscriptions or setups to use the live connection feature. It's included in your Pro license. This means you can connect to your semantic model (or shared dataset) in the Power BI service without having to import data every time. This approach is particularly beneficial as it ensures all your reports are always in sync with the latest data and you only need to refresh the data once in your semantic model.
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Helper IIICan you please point to any videos or courses that explain this in detail? It gets too difficult to ask all questions that arise, mainly when my background is not a tech background.
- v-hashadapu
Hi arunbyc , thank you for reaching out to the Microsoft Fabric Community Forum.
There are several courses in youtube one can learn from. Below are the links to the videos and Microsoft Learn Documentation that i recommend. :
You can find Microsoft doucumentation on almost everything PowerBI here:
1. https://learn.microsoft.com/en-us/power-bi/?wt.mc_id=powerbi_inproduct_settings
2. https://learn.microsoft.com/en-us/training/powerplatform/power-bi
For Individual Courses try these:
1. Learn Power BI: Tutorial for Beginners -Full Cours... - Microsoft Fabric Community
2. https://www.youtube.com/watch?v=cyWVzAQF9YU
3. https://www.youtube.com/watch?v=xDgyDXyu6FQ
4. https://www.youtube.com/watch?v=ENZm_7jWU4Q
5. https://www.youtube.com/watch?v=MII8NIF98RM
6. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
7. https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
8. https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-manage
9. https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install
10. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.