Forum Discussion

DaveBoehm's avatar
DaveBoehm
Regular Visitor
4 years ago

Combining data from two different online data sources in the same .pbix

I have login ID's for two different clients of mine.  I've developed Power BI reports for both different clients and published these reports to their own domains.  I would like to pull data from both of my clients into the same report.

 

My clients are both using MS Dynamics 365 Business Central as their ERP solutions.  I sign in to Power BI using my credentials for the first company (i.e. [email protected]).  I also set this login ID and password as the credentials in "Options and Settings".  At this point, I can go to "Get Data>Online Services>Dynamics 365 Business Central" to access this client's data.  Okay, no problem.

 

Now I want to bring in data from my other client's instance of Business Central.  I can change the log-in as [email protected].  I can also set this login ID (with the password) in Options and Settings.  I can access the second client's instance of Business Central, but when I click on "Load", I get a load error.  For the data coming from the first client, each table indicates the name of the table along the the message "The key didn't match any rows in the table".  The load for the table from the second client fails, also.  Of course, the message here is "Loading blocked by failures with other queries".

 

Does anyone know of a way to get around this situation?  I would love to be able to pull data from each of my clients online ERP solutions, into the same Power BI report.

2 Replies