The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have two tables that I want to merge. Both tables work fine individually and the credentials are signed properly for each individual table. However, when I go to merge its saying I am missing credentials. When I click the button to add credentials it just doesn't work. This is only happening on PQE online for a dataflow. PQE in desktop merges them without a problem. One table is an excel on a file server and the other table is a SQL table. I don't get the issue since both tables are find individually and only have issues when merging. I have tried merging and merging as new. I have also tried to flip the order that the merge takes place (Table 1 left join Table 2, Table 2 right join Table 1) None of these steps have worked.
Any help will be super appreciated!
Solved! Go to Solution.
@JaromBIDEVatDK try disabling the data load for everything except Merge and check this
@JaromBIDEVatDK try disabling the data load for everything except Merge and check this
It was the project option! It was turned off. Thank you so much.