Forum Discussion

horiagrosu's avatar
horiagrosu
Regular Visitor
10 years ago

We don't support settings for this dataset

All,    I'm hoping to get some help with the issue "We don't support settings for this dataset." Here is a brief background of our configuration:   1) We have MS SQL Server that hosts a number of...
Need Help
horiagrosu's avatar
horiagrosu
Regular Visitor
10 years ago

Jesse,

 

I do recommend to reconnect using the IP address instead of the host name. Let me know if this solves your issue if not we can try to troubleshoot further.

 

-Horia

bhunt's avatar
bhunt
New Member
10 years ago

what about named instances...that makes things a little more difficult. 

  • nbradbury's avatar
    nbradbury
    New Member
    9 years ago

    Good Afternoon All,

    I have set up the Enterprise Gateway and am able to see the gateway in Power BI and connect to our SQL Database. I am able to create reports in Power BI Desktop and upload them. When I go to Settings > Datasets I can see that the Gateway is Online and the Data Sources are online however it says "We don't support settings for this dataset."

    Someone said using the IP address of the server helped but I changed our settings to use our IP address and still receive the same problem.

    Kind Regards

    Nathan

    • elliotdixon's avatar
      elliotdixon
      Icon for Responsive Resident rankResponsive Resident
      9 years ago

      nbradburydoes it refresh any data at all?

      Can you do a scheduled refresh?

      Can you manually refresh the data?

       

      Perhaps try uploading a direct query file and see if that refreshes automatically - just to test the gateway is working correctly.

       

      Rgds

      ED

      • nbradbury's avatar
        nbradbury
        New Member
        9 years ago

        Hi ED,

         

        Thank you for the information.

         

        I didn't actually see the option to do a scheduled or manual refresh. I think I may have had an error in my understanding. I was looking at an existing Direct Query I uploaded and that did seem to update fine. Would I be correct in thinking that Direct Query does not work with the dataset settings?

        I uploaded an Import instead and I was then able to see the Dataset Settings as expected. So I am guessing everything is working as it should?

        Thanks
        Nathan