Is backend access required to view data for direct query Power BI?
I have sensitive data in snowflake.
I want to use the data for creating power BI reports. Now I want the data to be secure to a set of users.
Select single value fom slicer based on other slicer
Hi I am trying to Sync values from slicer based on other slice which have relation StartDT to StartDt_1 and EndDt to EndDt_1 (both have onetoone and Cross-filter “both”)
Here i StartDt_1 and EndDt_1 has bined to SQL query parameter’s
The reason i am doing to sync is StartDt_1 and EndDt_1 which are bined is i can not convert them as date’s as i am passing them as string in power query
Now , if select any date form StartDt it should reflect on Start_1 and same fpr EndDt’s
Power Query SQL – Slicer values displays as text instead of Date data type
Hi I have created dynamic M query which passes input slicer (i.e start date and End date)
The Query i have writen as below
OLE DB or ODBC error: Evaluation resulted in a stack overflow and cannot continue
One of my queries, in powerbi destop, contains Table.Combine
right after let
and i am trying to use is Table.Buffer but still the error persists. how to get around with this ? many thnaks in advance.
Error in output if column cell is empty or null in Power BI
While extracting a pattern from a text column in Power BI, I am getting an error if the column ‘Column1’ has an empty or null value. I have below code which works for non empty values but gives error if ‘column1’ cell is empty or null. I would like to skip the empty and null column values. How to fix this?
Select string which contains digit at second position and starts with ‘R’ in power BI
I need to select strings from a list which starts with ‘R’ and the string should have a digit at second position.
Extract a word with specific pattern in Power BI
I have a column named ‘Tags’ in Power BI which contains some text and want to retrieve the word matching the pattern ‘RXXXXXX’ into a new column called ‘Release’.The character after ‘R’ should be a digit. The word can vary in length.I have tried the below thing but it does not work as expected.
Custom Column with variable – Power BI
A variable create pointing a table value – var1. Variable refers to a column name.
Load current data from the Oracle database into Power BI and save/archive it there daily
Every day I load the current data from an Oracle database into PowerBI via SQL query. This table is then called tabLoad
, which always contains the same columns, although there is also the valuationtime
column in the form DD.MM.YYYY
, which indicates today’s/current key date.
This source query happens daily and only contains the current data from today. So I can currently only present the report as a daily report.
Power BI: Load current data from the Oracle database into Power BI and save/archive it there daily
Every day I load the current data from an Oracle database into PowerBI via SQL query. This table is then called tabLoad
, which always contains the same columns, although there is also the valuationtime
column in the form DD.MM.YYYY
, which indicates today’s/current key date.
This source query happens daily and only contains the current data from today. So I can currently only present the report as a daily report.