Forum Discussion
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 Birth
1 James 23.12.88
2 Catrine 23.10.77
3 Jim 23.06.67
If I would store the whole data in my private database and would want to transmit just the most necessary data to render it in the cloud (that happens at the microsoft’s cloud, as I have understood).
What data from the upper shown table would be transmitted to the dataset from data source for rendering purposes. The whole data or just the attribute names?
Thanks in advance,
Emil
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
7 Replies
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.
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
Hello again,
now I got some more information regarding the direct query.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/
In case I publish my data, how does the rendering work? Do I need to transfer it to the Microsoft cloud? I thought the rendering happens in the cloud anytime.
BR,
Emil
