cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
plammos Frequent Visitor
Frequent Visitor

[HELP] Incremental Load Power BI

Hello everyone,

 

I have a Power BI report connected with SalesForce Data, but SalesForce only have a transactional view and i need Historical Data

Is there any way that i can use Power BI for Data Storage, adding new rows and not modify the existent ones?

 

For exemple: 

 

If i modify an object in SalesForce, it only change the existing row and loses the previous data, i need this:

 

Object      Status        Volume      Date

  X         Negociation     500       01/02/2019

 

If i change the Status to Closed for exemple, that's the view i need:

 

Object      Status      Volume      Date

X         Negociation     500        01/02/2019

X         Closed              500       16/10/2019

 

I appreciate the help

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: [HELP] Incremental Load Power BI

Hi @plammos ,

 

Your demand is a good idea, while it is not supported to implement in Power BI currently. You can post your new idea in Idea Forum , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
plammos Frequent Visitor
Frequent Visitor

Re: [HELP] Incremental Load Power BI

i export the table to CSV using Python in Power Query, so every refresh it Export a CSV to a Folder

 

Than i can Use the CSV, Append to the Actual View SalesForce and again export to a CSV, this should do the work

 

But my problem now is that i can't save the CSV on a local Folder, i must save in Sharepoint and i couldn't do that yet

 

If anyone has a solution for this or another method please tell me,

 

Thanks

Community Support Team
Community Support Team

Re: [HELP] Incremental Load Power BI

Hi @plammos ,

 

Your demand is a good idea, while it is not supported to implement in Power BI currently. You can post your new idea in Idea Forum , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,402 guests
Please welcome our newest community members: