Service and File Together in One Model

[tamirk]

Hi,

I Have a model constructed with Power BI Desktop over salesforce data objects. I published it and schedule refresh which worked out just fine.

I also wanted to add some static data.

For instance, I have a country field in salesforce, and wanted to add a country group field according to my personal mapping. if I add this thourgh an excel local file, I can't use refresh. I tried to put it in one drive, but the desktop app doesn't seem to have a way to add it.

Does anyone have a suggestion on how to approach this?

Thanks,

Tamir

[konstantinos]

I have only tried it with excel powerquery many versions before..not sure if anything changed..
Double check that the folder in OneDrive plus the query settings must be public..( probably you have done this )..

[konstantinos]

Have you installed Personal DMG in order to schedule the local excel file? 

In my opinion best is to store the excel file in onedrive (as you did ) but you need to import the data  in PBI Desktop from excel using "From Web" and provide the onedrive path..This way you can refresh the excel file & salesforce since all data sources will be in online (cloud)..( not test with salesforce)

P.S. Do not just copy paste the path from browser - needs a to tweak it a bit - reference this

http://community.powerbi.com/t5/Integrations-with-Files-and/Power-BI-Desktop-import-data-from-excel-...

[tamirk]

No I haven't. I just want to use the free version for now and not go pro.

I see the web source option, but I don't get how to format the link - I've made a few trys and I keep getting a table in Power BI with the fields: Kind, Name, Children, Text

The link you provided is about sharepoint and I couldn't find something for me there.

Thanks,

T

[konstantinos]

The link is for shrepoint & for OneDrive Bussiness which use sharepoint and the path structure is the same..If you refer to OneDrive personal check this:

http://www.sqlchick.com/entries/2014/8/17/using-power-query-to-get-data-from-an-excel-file-in-onedri...

[tamirk]

Hi,

Thanks for that. Indeed I'm using a personal one drive.

However, the result inside the desktop app is not as the screenshots in the link. I only see the "Document" sheet and the fields like before:  Kind, Name, Children, Text

T