Forum Discussion
Editing Reports in Power BI but don't want changes affecting Salesforce Original Reports
gnuoryx Connecting to any data source will "import or read" data from your source into Power BI. So, what you're doing is creating a new copy of that information, you don't need to worry about your source data in Salesforce being modified.
Power BI doesn't "write/export" data back to the source data. So the new columns you've added in Power BI won't show up or be added to Salesforce.
If you save your Power BI file, it will create a PBIX file of your new datamodel that you've created.
Thanks so much Eno1978; I tried it out and indeed it worked.:smileyvery-happy:
I think it's because your Salesforce Report includes 3,150 rows of date yes? However, Power BI will only let you bring in 2,000 rows from the report so it's not a chart display issue, it's simply because all of the data isn't there...
gnuoryx Sorry, didn't see this. If you want to address anyone on the community in a post put the "@" before their name, and it will turn yellow. This will send them a notification that someone mentioned them. To address the other part of your question, you can only change elements in your model in the Desktop, the Service is just to connect and share, not modify your model/dataset.
@Eno1978 Thanks. My problem actually that the I have a text field in my data set with the words "male" and "female" for sex distribution of my beneficiaries. When I create a chart (pie, histogram) it does not count the total males and femaes instead I keep getting a less number. The total dataset should be 3,150 but when ever I graph, the dtaset totals to 2,000. I can't seem to understand how to get around this. I wold be glad for any assistance in this regard. Thanks.
- Greg_Deckler
Community Champion
Do you see a little yellow ! in the upper left of the visual? If so, it is truncating your data and I'm not sure there is a fix. One thing that you could do would be to create a separate table with "male" and "female" and the second column would total SUM the related entries from the original table. Then you could use this new table as the data for the pie chart, which should get around this visualization data limitation. You might be able to do the same thing with measures, I'd have to try that.- SnoJa10
Advocate IV
I think it's because your Salesforce Report includes 3,150 rows of date yes? However, Power BI will only let you bring in 2,000 rows from the report so it's not a chart display issue, it's simply because all of the data isn't there...
