Forum Discussion

emil_melikov's avatar
emil_melikov
Frequent Visitor
10 years ago
Solved

Which data does the dataset consist of?

Hello community,   Could someone help me and explain what part of data is transmitted from the data source to the data set.   Pls. picture the following example.   ID        Name        Date of...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi emil_melikov,

    Firstly, as other post, when you use DirectQuery feature, the data will not published into Power BI. Only attribute names are published in dataset in Power BI. The dataset will always store in Power BI as long as you don’t delete it.

    Secondly, for the rendering engine of Power BI, please review the blog and greggyb’s reply in this case.

    Thirdly, third parties will not be able to get access to your data during the rendering process. For more details about Power BI Security, please review this article.

    Thanks,
    Lydia Zhang

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

emil_melikov Dataset that you import in power bi desktop and publish gets published as a whole. So not just the attribute names but the actual data gets published as well. Alternative to that is to use directquery feature where no data gets published to power bi service but live connection is made from power bi service to data source on-premise and each time you interact with visual queries are executed against on-premise data source.

  • emil_melikov's avatar
    emil_melikov
    Frequent Visitor
    10 years ago

    Hi Ankit,

    many thanks for helping!

     

    What is meant by the direct query? Is that the live query?

     

    If we would consider the Power BI architecture. There is a way to connect to the on-premise database over the enterprise gateway. In this case I would need to use the live query. But as I have understood, the dataset that is transmitted to the Microsoft cloud consists of a part of the general data.

     

    Is there a way given to keep all data on premise, without to put it in the Microsoft could at all?

     

    Best regards,

    Emil

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Hi emil_melikov,

        When you connect to on-premises SQL Server database by using DirectQuery feature in Power BI Desktop, create report and publish it to Power BI Service, the dataset in Power BI  Service is always up-to-date once you add data source for the SQL Server database under on-premises gateway.  However, you’ll need to refresh manually so Power BI Service can refresh the data in your reports and dashboards for you.

        Reference:
        https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/

        Thanks,
        Lydia Zhang