Forum Discussion
Direct Query No connection Details
Hi GaryAtGW
If you want me to pinpoint the exact miss
Share two screenshots from the Service:- Your composite dataset >> Settings >> Gateway connections (showing Data sources + Mapped parameters).
- The upstream dataset >> Settings showing the Allow DirectQuery connections to this dataset toggle.
That will make the gap obvious.
Hi GaryAtGW ,
Thanks for raising this in Microsoft Fabric Community.
The error occurs when one or more sources in the dataset are not fully bound in the service. Even if the folder path has been added in the gateway, the dataset still needs to have the folder source explicitly mapped under Gateway and Cloud Connections. Please confirm this mapping is in place.The semantic model does not require a gateway, but it is good to verify the connection settings there as well. Ensuring both sources are correctly mapped under the dataset settings should resolve the missing connection details message.
For reference: Add or remove a gateway data source - Power BI | Microsoft Learn
Please reach out for further assistance.
Thank you.
Thanks rohit1991 for your valuable guidance.
Hello!
Thanks for your response, answers to your points below.
1. It doenst say live connection. When i mean live its a constantly updated data pushed out so I dont need to hit the refresh button
2. Its set as the server not as the i: drive. I cant edit the gateway but i can see the folder path is there using the server name pathway and its got the green online. when i manually refresh it loads any new files in the respective folders.
3. I have build permission on all models. They have the direct query allowed. Even the owner and publisher or the semantic models i connect to runs into the same issue.
4. Theres no fix now, all the models load data seperatly. Its when i connect both it errors.
5. All privacy i set to are organisational and where its prompted Autho2
I will have a look at the 2 seperate reports and I wonder if i make an online dashbaord i can return the rows with a common column.
Thank you
Gary
Hi GaryAtGW
If you want me to pinpoint the exact miss
Share two screenshots from the Service:
- Your composite dataset >> Settings >> Gateway connections (showing Data sources + Mapped parameters).
- The upstream dataset >> Settings showing the Allow DirectQuery connections to this dataset toggle.
That will make the gap obvious.