Skip to main content
37 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
1 answer
67 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
94 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
  • 31
0 votes
0 answers
247 views

I have configured auto page refresh to occur every minute on my Power BI report. Understandably, what actually ends up happening is the page is only able to refresh as frequently as the 'admin ...
Joe Plumb's user avatar
  • 539
0 votes
1 answer
194 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
0 votes
1 answer
55 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
1 answer
56 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
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
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
0 votes
0 answers
489 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
191 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
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
1 answer
58 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
1 answer
524 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
596 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
1 vote
0 answers
58 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
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
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
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
3 votes
3 answers
31k 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,325