Forum Discussion
Data categories on semantic models
Thank you again for trying to help. As I mentioned in another comment: "Another thing I noticed, I can't use conditional formatting when connected using direct access to a semantic model. I wonder if it is a bug or a limitation."
I ended up changing my strategy. I am no longer using dataflows and just using a semantic model connected to a mirrored database. Dataflows were not worth the effort in our case, and the loss of flexibility.
Hi rafasiqueira ,
I am not 100% sure the question....but, yes, you can set a column to a URL in the dataflow www.yahoo.com" but you cannot "mark it" as datatype called "URL". That can only be done in Desktop and Service directly in the formatting on the visual side.
Sorry, but I don't understand your mention of yahoo.com. So I will just consider it some sort of typo. Usually, when there is a local model, then setting the data category for a column is straightforward. But notice that when building reports in direct-query mode, the column tools are unavailable either on the Desktop or on the Service side. See screenshot below:
Unless I convert the report from direct-query, in which case the options are available again. My question was if it can be done in direct-query mode if I am the owner of both the dataflow and the semantic model.
Hi rafasiqueira ,
What I was stating is that in Dataflow you can't change the format in the column tools to URL. My point was that you could make the text equal to an URL, such as "www.yahoo.com" or "https://www.yahoo.com" but you can't make it a URL datatype in a Dataflow.
However, you can't use DAX in a Dataflow. Therefore, I do not believe that you can do what you are asking to do.
You can suggest an idea to Microsoft to allow for that functionality though. Please let us know if you do create an idea so that we can all vote for it.