Palantir Foundry
If you are looking to connect to Palantir Foundry data source from inside Power BI, then you are in the right place. In this article, we will discuss the Power Query M Language code that you can use to connect to Palantir Foundry data source from inside Power BI.
What is Power Query M Language?
Power Query is a data connection technology that allows you to connect to various data sources, transform the data and then load it into Microsoft Excel or Power BI. Power Query is a user-friendly tool that allows even non-technical users to access and transform data. Power Query M Language is a functional programming language used to create queries in Power Query.
Connecting to Palantir Foundry data source from inside Power BI
To connect to Palantir Foundry data source from inside Power BI, we need to follow a few simple steps. The first step is to open Power BI and navigate to the Home tab. From there, click on Get Data and select SQL Server from the list of available data sources.
After selecting SQL Server, you will be prompted to enter the server name and database name for the Palantir Foundry data source. Enter the required details and click OK.
Next, you will be prompted to enter your Palantir Foundry credentials. Enter your username and password and click Connect.
Once you are connected to the Palantir Foundry data source, you can use the Power Query M Language code to create queries and transform the data.
Power Query M Language Code for Connecting to Palantir Foundry Data Source
The following Power Query M Language code can be used to connect to Palantir Foundry data source from inside Power BI:
let
Source = Sql.Database(“server name”, “database name”, [Query=”SELECT FROM your_table”]),
#”Changed Type” = Table.TransformColumnTypes(Source,{{“Column1”, type text}, {“Column2”, type text}, {“Column3”, type text}})
in
#”Changed Type”
In the above code, replace “server name” and “database name” with the server name and database name for your Palantir Foundry data source. Also, replace “your_table” with the name of the table you want to connect to.
Conclusion
In conclusion, connecting to Palantir Foundry data source from inside Power BI is a straightforward process. By following the steps mentioned above and using the Power Query M Language code, you can easily access and transform data from Palantir Foundry data source in Power BI.
