Forum Discussion
Data Source Loading issue - Double execution of single query to different sources
Experienced Power BI developer, and I've run into an issue I've never seen before. I have a report query, that when executing a refresh, first loads from the proper SQL server/database; and then atte...
nash2z This is strange - so you are saying in PQ you have only one query using SQL server and there is no other query, correct? How do you pull data from SQL, table, or views or using SQL query?
There are 3 queries total - all SQL Server based. 2 of the 3 and the unsuccessful 2nd query in question attempt to load from the same server/db. PQ is not using the explicit SQL (available to be placed in the 'Advanced Options' window) but is using PQ's 'Import'. And here is where the issue is, I believe - but I don't know of any logs I can check to see what's going on underneath the covers of the 'Import'