Altering a dataset after loading large amounts of data

[Minions]

Hi!

I am new to PBI. Ran into this issue.

Created a dataset with one week FACT data (5 mill records) with a couple of dimensions. Published it to the Premium service.

Then created historical partitions and loaded 2 months of data into it using SSMS through XMLA. From Desktop Pro I am able to connect and report on it.

Now I wanted to add one more dimension to the data set and relate it to the FACT table.

Desktop pro has all options disabled when directly connected to the dataset at the service. So I tried downloading the .pbix file to see if  I can edit it locally. It said that the .pbix file cannot be downloaded. Signed off and signed back in. No luck.

Can you please suggest some options for me or point me what I am doing wrong in the above steps? If I cant edit a published large data set Do I need to have my model perfected with all the dimensions and measures before I start loading historical data into the partitions?

Thanks 

Prem

[Minions]

Got the reply from MSFT support.

Couldnt download due to below reasons.

• Datasets with incremental refresh can't be downloaded to a .pbix file.
• Datasets enabled for large models can't be downloaded to a .pbix file.
• Datasets modified by using the XMLA endpoint can't be downloaded to a .pbix file.

Looks like ALM is the only way to edit the large DS in a premium capacity

Thanks for your help

[v-rzhou-msft]

Hi @Minions 

Download PBIX file in Power BI Service has limitations as below.

You can try to connect power bi dataset and add a new table in desktop.

From your statement above, when you connect to power bi dataset in PBI Desktop, you find all options are disabled. It is caused by the connection mode. When you connect to dataset, the connection mode is live connection. Currently, here is a preview function called: Direct Query for Power BI dataset and Azure Analysis Service(Preview).

You can connect to Power BI dataset by Direct Query and then you can use all functions in Direct query mode, like add a new table and add new relationships.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Minions , download pbix is permission at power bi service and that can be enabled by admin under tenant settings.

if you have modified pbix, you can use ALM toolkit to migrate changes

https://www.sqlbi.com/tools/alm-toolkit/

[Minions]

Amit

Download is enabled by default fo the Entire org. I get this error.

Activity ID: 14e78982-9b6f-48e2-8c7d-7ccd29d39119
Request ID: 1d994b3d-3ab7-5861-20eb-9b32b4918458
Correlation ID: cfa6c631-407b-2f04-c744-2f15b7df150b
Status code: 403
Time: Thu May 20 2021 07:56:08 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.16039.63
Client version: 2105.1.06194-train
Cluster URI: https://wabi-us-east-a-primary-redirect.analysis.windows.net/

[Minions]

Thanks Amit. Let me try this and get back to you.