cmcreynolds
Active Member
- Joined
- May 21, 2015
- Messages
- 295
So, I have two files on OneDrive right now that read from the same tables (translation tables also on OneDrive) and website (Salesforce).
However, in report A (the older), I pulled Salesforce objects and used "Relationships" to join them. In report B, I thought I'd be fancy and "Merge" in PowerQuery.
Now, when I use PowerBI to schedule refresh, report A works fine but report B gives me a message saying there are "sources that currently don't support refresh." Same sources in B than in A (in fact, A may have one more, additional source).
Report A's diagram view is REALLY complex - that is what I thought I was "helping" when I used "merge" in report B.
Should I just not use PowerQuery's "merge" function? Is there any member who knows WHY it would prevent scheduled refresh?
However, in report A (the older), I pulled Salesforce objects and used "Relationships" to join them. In report B, I thought I'd be fancy and "Merge" in PowerQuery.
Now, when I use PowerBI to schedule refresh, report A works fine but report B gives me a message saying there are "sources that currently don't support refresh." Same sources in B than in A (in fact, A may have one more, additional source).
Report A's diagram view is REALLY complex - that is what I thought I was "helping" when I used "merge" in report B.
Should I just not use PowerQuery's "merge" function? Is there any member who knows WHY it would prevent scheduled refresh?