Forum Discussion

Katie_L's avatar
Katie_L
Helper I
5 years ago

PBI - PowerApps: Dual Storage

Hello,   I am trying to build a PowerApp in PowerBI that is synced with my visuals. The data souce is a Sharepoint List. I understand that my query must be in Dual Storage Mode. Problem: This query...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Katie_L ,

 

Tables with Dual setting can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-demand query to the data source.

 

Since sharepoint list only supports import mode, you cannot use Direct Query and Dual storage. You can refer to https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources for data source support both import model and DQ model.

 

If this post help, please consider accept it as the solution to help other member find it more quickly.

 

Best Regards,

Dedmon Dai

Katie_L's avatar
Katie_L
Helper I
5 years ago

Thank you for this. I this case I can make a Streaming Dataset and pull in my Sharepoint Columns. **Question** if I do this, HOW do i push all existing info into the dataset?

 

I know I can make a FLOW and add a row, but this doesnt get all historic data. 

Thoughts?