Call today 0845 643 6463

Tag Archive: Blog

  • Connect Azure Data Studio to Microsoft Fabric

    August 30th, 2024 in Blog

    Azure Data Studio and Microsoft Fabric As organisations increasingly adopt Microsoft Fabric for their data warehousing and analytics needs, finding the right tools to speed up development is crucial. Connecting Azure Data Studio to Microsoft Fabric can streamline your workflow, enabling you to navigate environments, pinpoint variances, release code, and assign memorable names to connections instead of relying on lengthy connection strings. Step…

    » Read more

  • Ownership Made Easy: Microsoft Fabric Warehouse Takeovers

    June 19th, 2024 in Blog, Data Lakehouse, Data Warehouse, Fabric

    Fabric Warehouse Ownership Takeover As part of your project you have created and developed a Fabric Warehouse and now it is time to transfer the ownership of it away from your account to a production Service Principal Name or someone else in the organisation to maintain. There’s no simple method in the GUI so how do you do it? You use the Takeover API. Let’s go through the process step-by-step but beware, there is one caveat, you MUST…

    » Read more

  • Using Stored Procedure as a Power BI Source (with parameters)

    April 9th, 2024 in Blog, Business Intelligence, Power BI, PowerBI, SQL, SQL Server

    Using a SQL Server stored procedure as a source in Power BI We might be most familiar with using a view as the source to our PBI datasets, a series of views creating a series of tables. This can be great but when handling more complex view queries with lookups, you might find yourself with a severely long refresh and even an error. This is where a stored procedure is required – this gives you more control layer by layer in the source query.…

    » Read more

  • The Power of Contribution: Why Creating Content Matters in the Data Community

    The Power of Contribution Why Creating Content Matters in the Data CommunityFebruary 7th, 2024 in Blog, Community, Other

    Many people, including me up until a year or so ago, believe that between the documentation, videos, blog posts and experts delivering sessions on specific tech, that there is no room or necessity for them to create content or teach. This is simply not the case! So, in a world seemingly saturated with learning material, why should you bother creating more? Different Perspectives How often have you read a blog post, not really understood it, read…

    » Read more

  • Connecting Your Fabric Data Warehouse to Spark Notebooks

    January 19th, 2024 in Blog, Data Lakehouse, Data Warehouse, Fabric, Python, Spark

    When using Spark notebooks in Fabric, it is very easy to connect directly to a Lakehouse. From here, you can see all of the data that is stored in tables and click and drop to insert code snippets to extract the data. Here at Purple Frog, it is common to have projects using Data Warehouses as their data store. When looking at ways to connect Notebooks to a warehouse, there is currently  little information available online; One way that is…

    » Read more

  • Upload files to a LakeHouse in OneLake using Powershell

    January 12th, 2024 in Azure, Blog, Fabric, OneLake, Power BI

    In this blog post, I will be sharing a PowerShell script that uploads files to a OneLake Lakehouse. This is the script: The script is downloadable at the bottom of the page as a txt file. To use the script there are few steps: Install the Powershell module Az.Storage. This code exists in the script and just needs to be uncommented for the first run, if the module is not already installed. Fill in the variables at the top of the script: tenantID…

    » Read more