Skip to main content
36 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
93 views

My Power Apps connects to Microsoft Fabric SQL Analytics Endpoint via DirectQuery. The published app works flawlessly - zero errors, perfect data display, users love it. Power Apps Studio shows on ...
moski's user avatar
  • 87
1 vote
1 answer
82 views

Using Power BI directQuery to databricks SQL warehouse, I see the queries getting generated to compute an average have SELECT SUM(CAST(int_field AS DOUBLE)), COUNT(int_field) FROM fact ...
Nathan Jones's user avatar
  • 11
0 votes
0 answers
124 views

I want to create a database in Analysis Services Tabular 2022 (compatibilityLevel: 1600) in c# using the TOM Api (tabular object model) but I can't I can create the database in Import mode, and also ...
Alberto Gentilcore's user avatar
  • 30
0 votes
1 answer
85 views

I have three data sources : 1. An Excel file that I loaded from my computer 2. A Sharepoint on Cloud 3. A Sharepoint on premise So of course, I cannot connect on Powerbi Premium online to two of the ...
Oimat's user avatar
  • 33
0 votes
1 answer
134 views

I have built 14 AWS Glue jobs (using Pyspark) that retrieve data from a few sources, partition the data by a "uuid" field and write them to S3 in parquet files to be consumed through AWS ...
Pedro Montezuma's user avatar
  • 15
0 votes
1 answer
255 views

I'm working on a Power BI report that requires me to connect to a specific table in my SQL database. However, I don't want the entire table set to be loaded automatically when opening the report as ...
Pauliuuss's user avatar
  • 109
-1 votes
1 answer
1k views

I have created several Power BI reports and am using DirectQuery connections to a SQL database to pull the data. When I try to publish these reports to the Power BI Service I get the following error: ...
prgmmr101's user avatar
  • 9
0 votes
1 answer
63 views

when I try to parse answers in JSON, I can not receive the data I need as the key (Row 1 - **ecf2f5d0c94747a595765cca40443262_2_1**, Row 2 - **ecf2f5d0c94747a595765cca40443262_2_123**) is always ...
Марсель Щербинин's user avatar
  • 1
0 votes
0 answers
226 views

I am trying to run a SQL Server stored procedure in Power BI that has parameters and I am getting this error: DataSource.Error: Microsoft SQL: Named Pipes Provider: Could not open a connection to SQL ...
Gbade Aina's user avatar
  • 1
0 votes
1 answer
72 views

I have the following two tables - App and App Role joined on 'ApplicationID'. There exists only one ApplicationID row in App table but multiple ApplicationIDS can exists in App Role table. Application ...
khushboo shah's user avatar
  • 5
0 votes
1 answer
314 views

I have a query that get the number of days from the user and display the result, like the following: declare number_of_days = 10 select * from myTable where getdate() - opendate > number_of_days ...
Mehrsa's user avatar
  • 3
0 votes
1 answer
2k views

I have a problem with the DATEDIFF formula in Power Bi. I need to perform a DATEDIFF between two dates, which are in a fact table with more than 17 million rows. The difference number between these ...
Keven P. Oliveira's user avatar
  • 1
0 votes
1 answer
753 views

I have a set of data with this range 0-10, 11-20, 21-30, and exceed 30. My data was loaded to power BI using direct query. I add column from selection in transform data. I was able to auto generate ...
gudeThings's user avatar
  • 13
0 votes
1 answer
1k views

I work with a many data tables which I am using for reports creation. Because data sources are slow and tables have huge size ( Odata ), I have to change the way how to update data. My idea was to ...
CheliosSk's user avatar
  • 23
2 votes
1 answer
2k views

I'm having some trouble using DirectQuery for Power BI datasets and Analysis Services: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services I ...
Bryan Rock's user avatar
  • 632
0 votes
0 answers
493 views

I'm working on a project to ameliorate my skills using power BI i created 3 tables on Oracle DB (data_2018, market segment and meals) i imported the data on power BI with direct query using this ...
TIM_123's user avatar
  • 13
0 votes
1 answer
100 views

I have a column column1 in powerbi where the majority of rows are Numeric and the minority is Text. How can I calculate column1 multiplied by another column columnX in a new column, while ignoring ...
Clueless2's user avatar
  • 1
0 votes
1 answer
200 views

I wonder if it is completely necessary to set the data conectivity mode to Direct Query when you want it to set the incremental update option. I had set it to Import the first time and I don´t know if ...
Benjamin Lahsen's user avatar
  • 35
0 votes
1 answer
234 views

At this point I am trying to Enable query folding for my DirectQuery on an Oracle Database. This so I can increase my "refresh speed". By refresh speed I mean the time it takes to reload my ...
Jarny K's user avatar
  • 1
0 votes
2 answers
3k views

What is the fastest way to get data from an Azure Data Lake Gen2 to PowerBI? Data is Updated every 5 minutes and it must ingested trough DirectQuery Currently: I have large tables that get updated ...
Sofia's user avatar
  • 1
0 votes
0 answers
35 views

We are creating PBI report with data sources in Direct Mode. Row level security has been implemented through some tables. While viewing the report with data security , we could see a lengthy where ...
Abishek VK's user avatar
  • 524
0 votes
1 answer
63 views

I want to create a conditional column using DAX, which compares 2 date columns and a status column that derives a condition. I have tried this code: Status of Feedback = IF ( ISBLANK ( 'DAT ...
Avinash Rao's user avatar
  • 1
0 votes
2 answers
964 views

I have a model imaged below. Let me explain the model. Note: All connections are SQL connections using Microsoft SQL. Buffer_Data is my fact table. Buffer_Data is a log of everything from customer ...
MartyMcfly0033's user avatar
  • 188
0 votes
1 answer
564 views

I was wondering, when you get the data in power bi (with Direct Query) And you filter the data in the Power Query Editor.(Lignes filtrées = Filtered rows) You will get the data first then you filter ...
MoonLightFlower's user avatar
  • 183
0 votes
1 answer
1k views

I'm developing a PowerBI report in DirectQuery. I introduced a measure with the syntax ALLSelected (RemoveFilters) because I need to calculate some data removing a contextual filter based on the ...
MFF's user avatar
  • 157
0 votes
1 answer
637 views

I need to create a measure (DirectQuery mode) in order to calculate the number of rows that have the same values for the field [OriginType] excluding the ones that comes from the same parents. ...
MFF's user avatar
  • 157
0 votes
1 answer
1k views

I am struggling to switch the Month number (1=Jan , 2=Feb , ... ) column into Months label(Jan , Feb. , Mar,... ) . My main problem is that am using direct query which poses a lot of restrictions on ...
Ammar Noor El Din's user avatar
  • 1
1 vote
0 answers
59 views

Our composite model using directquery to get the data from the first layer of dataset since want to make sure the tables from golden dataset will not be modified by the users. (shown below) enter ...
puffy's user avatar
  • 11
0 votes
1 answer
998 views

I'm trying to have multiples reports with same dataset in a single workspace with Power BI. I know I have to use "Power BI dataset" in Power BI Desktop. But every time I publish, it creates ...
SRP's user avatar
  • 288
0 votes
1 answer
3k views

I want to establish direct connection from postegresql DB with power bi. I am using DBeaver as environment and I can only connect to power bi using ODBC. I need direct query so I could visual big data ...
nemd's user avatar
  • 43
0 votes
1 answer
1k views

I have a Power BI dashboard which has direct queries to an Oracle database, where I import data using SQL queries. On my local pbix file everything is fine. When I publish it to my enterprise powerbi....
Ferhat's user avatar
  • 416
0 votes
1 answer
2k views

There is a scenario were we are using REMOVEFILTER DAX function to remove the effect of few columns on the calculation(measure). What we could observe is, the function is working fine till it has ...
Pratik Futane's user avatar
  • 71
0 votes
1 answer
792 views

Can I use Power Automate for Direct Query data refresh in Power BI? Will it be faster than the Enterprise Gateway Direct Query Connection?
Student of the Digital World's user avatar
  • 3,051
0 votes
1 answer
3k views

For some reason I have in a PowerBi dashboard multiple queries that were switched to import mode rather than direct query. Is there a way to set an existing query to direct query without recreating ...
c0bra's user avatar
  • 1,090
0 votes
1 answer
5k views

I'm working on a DirectQuery dataset in Power BI and I notice that Transform data/Query editor is disabled for DirectQuery mode, usually it'd return a message something like: This step results in a ...
nilsinelabore's user avatar
  • 5,375
3 votes
3 answers
32k views

I want to convert a Timestamp column to date column in my table. I tried to create a measure with DAX: Date = FORMAT('my_table'[Timestamp], "dd/mm/yyyy")*1 and caught error: A single value ...
nilsinelabore's user avatar
  • 5,375