I am trying to set season ranges for specific dates coming from my DTBL_SCHOOL_DATES table. Below is my logic which works based on the year and its region to set the season per a given range. CASE WHEN RTRIM(dtbl_school_dates.local_school_year) =…
I want to replace some acquaintance values by keywords to specific value, converting both "google" and "searching google" to "seo" I tried replace but you should specify all the values to replace with and that's not possible. if there is…
I'm working in Kusto Query Language and I would like to display not everything from the selected string. My string is 'Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 50000.…
I need to set up my connection with PowerBI to Azure Database for MySQL flexible server. I can't seem to find any reliable documentation to do this. Initially I'm getting this error when I try to connect to the server.…
So I want to let users to export reports from the website as an end user, without using power Bi application. I already has everything set server side, I am following this code sample from Microsoft's documentation , but after…
I have a Azure Synapse SQL table which contains a list of companies. I have created an access matrix, security predicate and policy to filter data presented based on the user. Create FUNCTION spf.rls_securitypredicate_dimcompany(@Companycode AS nvarchar(50)) RETURNS TABLE WITH SCHEMABINDING…
I'm running a PowerShell script in Azure function (Timer Trigger) which will fetch PowerBI workspace data from Azure and it will store to Blob storage. I want the output data of the Azure function to be stored in csv format…
Hey everyone I am trying to connect Powerbi to my data lake gen 2 on azure I am set as Storage Blob Data Contributor Aswell as Storage Blob Data Reader on the Storage account level i am not sure if…
I'm fairly new to Power Query and have hit a hiccup that's been bothering me all day. I've read multiple threads here and on the Power BI community and none has really cleared my question, and my logic suggests a…
I would like to connect my SQL Database on Siteground Hosting to Power BI through the SQL Server connection. However, I need to get the following information which I am not sure where to get: Siteground Database Credentials in the…