Forum Discussion
using PBI as data storage/Data repository
Hi MaryamSe
For what you are suggesting I would suggest using Power BI desktop to consume the data.
The configure the semantic model with Incremental Refresh, here is how to do this:Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
And then upload and refresh the semantic model in the Power BI Service and then the users can connect via Excel.
Hi MaryamSe
For what you are suggesting I would suggest using Power BI desktop to consume the data.
The configure the semantic model with Incremental Refresh, here is how to do this:Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
And then upload and refresh the semantic model in the Power BI Service and then the users can connect via Excel.
Hi, Thank you very much Gilbert.
May I ask whay do you suggest PBI desktop. My concern is using PBI desktop needs to be on someone computer. I would prefer having a model that is shared on the workspace.
Data are on several execl sheets ( more than one single source of data - I may need to appned them). The updated data include the new and updatde (overwriten) ones. But, It seems that incremental refersh requires using only one source of data.
Thanks again for your help
From the source you shared "When you configure incremental refresh and real-time data by using Power BI Desktop, or configure an advanced solution by using Tabular Model Scripting Language (TMSL) or Tabular Object Model (TOM) through the XMLA endpoint, all partitions, whether import or DirectQuery, must query data from a single source."
