Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone one,
I am new to power query/power bi. I am trying to link the file from external soure to my consolidation file but getting this message..
"you can't refresh a connection only query". All i am trying to do is brought in file from a folder.
Help from any of you is much appreicated.
Thanks in advance.
Connection only queries are only refreshed/calculated if another query depends on it. If nothing is using it (it isn't loaded to the model, or to a spreadsheet in Excel) then Power Query won't bother calculating it because it goes nowhere.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @harris_ali ,
Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Hi @harris_ali ,
Does there a query exist after you import it such as following picture? Could you try to describle the reproduce steps simply about getting this error? If you want to get files in Folder, we can try to use the Get Data - Folder to meet your requirement:
Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Is this Excel?