I am using PowerBI to connect to CRMOnline Data. When building my report using PowerBI desktop I connected to a Dev environment. After completing and testing my report I re-pointed all queries within my report to my production environment which is in a different tenant. I find however that when I publish my report to PowerBI there is still a reference to the development environment data source and as a result the re-fresh of my data fails. Is there any way to permanently remove the old data source?
3 Comments
- Did you find some fix? I'm on the same boat.
- You can do this by adding / changing a little M 1) create a simple datasource with your tenant name 'let Tenantname = "contoso.onmicrosoft.com" in Tenantname' 2) use that in any sources that are tenant specific , such as : let Feed = "users", Source = OData.Feed("https://graph.windows.net/" & Tenant & "/" & Feed , null, [Query=[#"api-version"="1.6"]]), I genrally build the query first , then drop to the andvanced editor to change the first line
- Status added:Needs Votes
