Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Folks!!
I need to display data from Text file to Power BI, in Text file, we have data as below, i.e. detail for the hyperlink but in text format.
Data available in Text File :
Book is available at <u><a href=https ://docs.microsoft.com/en-us/power-query/connectors/quickbooksonline ms.pgarea=content ms.cmpgrp=body ms.cmptyp=link ms.cmpnm=QuickBooks Online ms.title= km.title= ms.interactiontype=1> QuickBooks Online </a></u> , please use the same.
Where QuickBooks Online is text that having hyperlink of mentioned URL
I need to display above text in Table visual and text shown will be like below
Book is available at QuickBooks Online , please use the same.
Where user click on QuickBooks Online and above link will get open.
Please suggest!!
Thanks
Amit
@amsrivas , You need to have text in one column and URL in another column, then it can work
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
Hi @amitchandak
Requirement is to have hyperlink data and normal data in one column only.
Thanks
Amit Srivatsava