You seriously need to change your DB to achieve this in any meaningful way: storing date based data in strings is always a poor idea and string comparisons are always based on the first different pair of characters - subsequent ones aren't even...

PowerBI

MebhiChokiDAR – Tweet Sentiment Analysis and More Using Microsoft Flow

22 Mar 2019 by Rajat-Indiandotnet

How to do sentiment analysis using few clicks and see live graphical representation using Power BI live feed

Indian Prime Minister 2019 Live Poll – Analysis using Microsoft Form, Microsoft Flow and Power BI Live

30 Mar 2019 by Rajat-Indiandotnet

Live Poll – Analysis using Microsoft Form, Microsoft Flow and Power BI Live

Office

COM

PowerBI

Create date and time in azure SQL query for your sensors in IOT hub

15 Oct 2019 by gcogco10

Hi Team I am trying to find a way to figure it out as to how to create date although its not on sensors input for my IOT hub. But i want to cater this field as field for my sensors like humidity and temperature. That each sensor needs to have date per dataset for my power bi desktop. What I...

SQL

Azure

PowerBI

Create date and time in azure SQL query for your sensors in IOT hub

14 Oct 2019 by OriginalGriff

One way to do it is to add a Default Values for Columns[^] which can include the date/time the row was inserted. Do that with a UTC default value, and there is no more work needed.

SQL

Azure

PowerBI

How do I have multiple embedded powerbi reports in a blazor project?

6 Nov 2022 by Will Sewell

I have a blazor project that embeds a PowerBI report however i'm struggling to get different pages to show different reports. Currently I can only get two pages to show the same report. I have a .razor page called "PowerBIReport.razor" which has...

Blazor

PowerBI

JSON

How to export multiple visuals of powerbi into one excel file in the different tabs

23 May 2023 by Member 14124697

I have imported raw data and created visuals (table) on PowerBI dashboard. for reporting purpose what i need is i want to export all the visuals (total 6 visuals available dashboard) into one excel file in the different tabs. How would i do that?...

Excel-2016

PowerBI

Facing error while creating report in powerbi using rest api

14 Jun 2023 by Graeme_Grant

You have an invalid character - 'f' headers = { "Authorization": f"Bearer {access_token}", "Content-Type": "application/json" } change to: headers = { "Authorization": "Bearer {access_token}", "Content-Type":...

PowerBI

How to create account for powerbi or other application to grant access using AAD

4 Aug 2023 by sai chinnu

I am currently using AAD groups to give access to my azure sql database. Some i give DB role based, some database contained for schema specific access. Now i have few accountID for PowerBI, Denodo and multiple other application access. Currently...

PowerBI

I need to create custom column using conditional statement.

13 Oct 2023 by Member 14124697

Hi there, I need to create custom column in the PowerBI using conditional statement. My condition is if reference column value is less than 5 then populate value as 0-5 Years, if reference column value is less than 15 then populate value as 5-15...

PowerBI

I need to create custom column using conditional statement.

24 Oct 2023 by CHill60

If you click on Add Column, then Conditional Column Ater the If select your reference Column Name, Operator 'is less than' and Value 5. Output '0-5 Years' Click on Add Clause Select your Reference Column Name, Operator 'is less than' and Value...

PowerBI

Correct values in power PI table based on values in other table

21 Jan 2024 by Hamza M. S. Abazeed

Hi I have a Power Bi Project, I have 2 tables, the first T1 has Column1 with Values edited wrongly, the values are for example: ss 1222--- Wkl8888 er -7777 1222 gf6 st. 8566 gh8888-- The second table T2 has the correct values (which are...

PowerBI

How to add last two month column data dynamically based on product

19 Jan 2024 by Sridhar Babu 2022

for eg in nov 23 for product 3245 having order of 50, in dec 23 for product 3245 having order of 45 Using Direct Query mode output: in jan 24 for product 3245 order should be 50 + 40=90 (nov23 product 3245 order + dec 23 product 3245 order). ...

PowerBI

Create date and time in azure SQL query for your sensors in IOT hub

15 Oct 2019 by gcogco10

Hi Team I managed to have a working around this, but i don't get a data from the date field. My code is as follows; Is there a way can be able to get latest date and timestamp? Please help me i am almost there with this, thanks? SELECT illuminance as illuminance, temperature as...

SQL

Azure

PowerBI

Facing error while creating report in powerbi using rest api

14 Jun 2023 by Ashwini S 2023

Failed to create report. Error: b'{\r\n "error":{\r\n "code":"","message":"No HTTP resource was found that matches the request URI \'http://wabi-india-central-a-primary-redirect.analysis.windows.net/v1.0/myorg/groups/me/reports\'."\r\n ...

PowerBI

How to Retrieve Logged in USERNAME in POWER BI Reports. A Perfect Alternate Way for Direct Queries

2 Jul 2019 by coded007

This tip gives a perfect alternate way for direct queries.

PowerBI

SSIS/ SSRS/SSAS confusions

12 Mar 2024 by Bakhtawar A.

hi I want to know about MS Report builder MS SQL Server Mobile Report Publisher POWER BI Report builder Power bi desktop version Now i want to to practise SSRS / SSIS/ SSAS with power bi .. so on which tool should i practise ? which is...

SSRS

PowerBI

SSIS

Sum of 2 months data and to show latest month data , top 50

11 Mar 2024 by Sridhar Babu 2022

I have table contains partno,location, col1,col2,measur1,measure2,measure3. Based on Measure3 has to show top 100 records. the thing is table loading two months of data. for eg. jan + feb data loading. based on partno, location, if any duplicate...

PowerBI