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,
Thanks for your response.
I understand that Power BI is not recognizing the column as a URL in table visuals as DirectQuery does not allow setting the Data Category in the semantic model.
You can try these work arounds and see if this solves your issue:
* You can use Conditional Formatting
* Or you can pre-format the URL in the Dataflow. If the column does not contain full
URLs, Power BI may not recognize them.
* If modifying the dataflow is not an option, try creating a calculated column inside the
semantic model.
Even though the Data Category cannot be explicitly set in DirectQuery, Power BI sometimes detects links if they are formatted correctly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
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.