Splitted PBIX file - Add columns in Power BI service

[WLFRD]

Hello,

I've been using Power BI Desktop for a while and since a day or so, I have splitted my .pbix file into a report and dataset. This dataset is exported to Power Bi Service. I have added some more SQL tables to this dataset so this will be a multi purpose dataset. This dataset will be the base for (all of) my future reports.

In many reports I added columns with DAX and conditional coloms but when I get rid of the data in those reports and connect it to the dataset in Power BI Service, many of the visuals need to be fixed because the added columns are not present in the dataset.

My questions are:

1. Do I have to add the added columns in Power BI Desktop to the dataset in Power BI Service? If so, how?

2. Is it possible to add conditional/DAX columns in Power BI Service without using Power BI Desktop?

3. Does Power BI Service have a Power Query Editor? 

Thanks in advance.

Regards.

[menglaro78 · Accepted solution]

HI @WLFRD ,

1. Do I have to add the added columns in Power BI Desktop to the dataset in Power BI Service? If so, how?
You rightly split the dataset from the report. In Power BI Desktop, open the file containing the dataset and add all the Calculated Columns to it. Republish the dataset to the service and your reports will work.
In fact, this type of entity cannot be created when you link a report in Live Connection to your dataset.

2. Is it possible to add conditional/DAX columns in Power BI Service without using Power BI Desktop?
This feature will be available soon. (Dataset authoring in the Power BI Service | Microsoft Learn)

3. Does Power BI Service have a Power Query Editor? 

Yes, is Power BI Dataflow feature (Creating a dataflow - Power BI | Microsoft Learn).

Marco

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!