How to create binary load file and Report only file in PBI ?

[Anonymous]

Hi All

i like to create a PBI file only store all raw data into Table. File name =A 

Then I get one more PBI file name =B , this file only display table and chart. And this file just need one line of script to read all data from file A.

Hope some one can share some link how to achieve this.

Paul

[vanessafvg · Accepted solution]

do you have access to the power bi service? if you upload the pbix file to the service, then you can use it as a dataset.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

[Anonymous]

Hi Vane

thank you for sharing. It help a lot.

i am using free desktop version , does it support? 

paul

[vanessafvg]

I don't think you need a pro license to use it for yourself, but if you want to share with someone else you would need to have a pro license, unless you let them upload the pbix themselves.

[Anonymous]

Hi Sir

since I am not sharing data with my staff . I only use it for myself. Do PBI free version allow me set auto schedule refresh the data at 3 Am daily ? So that I can view updated report from my ipad.

paul

[vanessafvg]

I would think so

you can see here what a free license allows you to do

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-features

you will need to do it in your workspace.