https://community.fabric.microsoft.com/t5/Desktop/issue-with-Date-table-in-directquery/td-p/1453319
issue with Date table in directquery - Microsoft Fabric Community
Oct 24, 2020 - Hello all, I am connecting to tables in SQL server in directquery mode. since I need to refresh the data every 10 min. I have created date table in
with datemicrosoft fabricissuetabledirectquery
https://community.fabric.microsoft.com/t5/Desktop/Refresh-not-working-due-to-DirectQuery-source-and-calculated/m-p/4658297/highlight/true
Solved: Re: Refresh not working due to DirectQuery source ... - Microsoft Fabric Community
Apr 21, 2025 - Hi , I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further
not workingdue to
https://community.fabric.microsoft.com/t5/Desktop/How-to-fetch-a-Column-from-Directquery-Table/m-p/4044202/highlight/true
Solved: How to fetch a Column from Directquery Table? - Microsoft Fabric Community
Jul 17, 2024 - Solved: Hi Expert, I am facing an issue to fetched a column from Directquery Table(Created in Power Query 'Fields Count' ). I am using RELATED
how toa column
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Allow-Bi-Directional-filtering-for-DirectQuery-reports/idi-p/4523194
Allow Bi-Directional filtering for DirectQuery rep... - Microsoft Fabric Community
Feb 25, 2025 - The dropdown for bi-directional filtering is disabled on DirectQuery reports. This makes reporting on star schemas difficult.
microsoft fabricallowbidirectionalfiltering
https://community.fabric.microsoft.com/t5/Desktop/Integrated-DirectQuery-data-with-Imported-data-cannot-be/m-p/3740098/highlight/true
Re: Integrated DirectQuery data with Imported data... - Microsoft Fabric Community
microsoft fabricintegrateddirectquerydataimported
https://community.fabric.microsoft.com/t5/Desktop/issue-with-Date-table-in-directquery/m-p/1453319
issue with Date table in directquery - Microsoft Fabric Community
Oct 24, 2020 - Hello all, I am connecting to tables in SQL server in directquery mode. since I need to refresh the data every 10 min. I have created date table in
with datemicrosoft fabricissuetabledirectquery
https://community.fabric.microsoft.com/t5/Service/SQL-Azure-Database-with-DirectQuery-not-automatically-refreshing/m-p/12028/highlight/true
Solved: Re: SQL Azure Database with DirectQuery not automa... - Microsoft Fabric Community
Dec 10, 2015 - Having to refresh the browser is an issue. I'd like to display direct connect data on TVs around the office. I can't effectively do this unless the
sql azure
https://community.fabric.microsoft.com/t5/Desktop/Basic-question-DirectQuery-cards-to-add-up-to-another-card/m-p/2239881/highlight/true
Solved: Basic question - DirectQuery cards to add up to an... - Microsoft Fabric Community
Dec 20, 2021 - Solved: Hi there, I have a dashboard in PBI Desktop which uses Direct Query to get data from Dataverse. This is great to present cards using Count to
basic questionto add
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/3176739
Re: Share your thoughts on DirectQuery for Power B... - Microsoft Fabric Community
Sep 18, 2024 - Hi that is not supposed to happen. Can you please open an issue on issues.powerbi.com or reach out to support in another way so we can collect
share your thoughts
https://community.fabric.microsoft.com/t5/Desktop/List-of-DirectQuery-data-sources/m-p/3191733/highlight/true
Re: List of DirectQuery data sources? - Microsoft Fabric Community
Aug 16, 2023 - Thanks! I found this too, but it's almost a year old. That can be horribly out of date at the speed Power BI sometimes moves! I was hoping to find
list ofdata sourcesmicrosoft fabricdirectquerycommunity
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/2418409
Re: Share your thoughts on DirectQuery for Power B... - Page 7 - Microsoft Fabric Community
Sep 18, 2024 - interesting, thanks for reporting.
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/2609322
Re: Share your thoughts on DirectQuery for Power B... - Page 5 - Microsoft Fabric Community
Sep 18, 2024 - Hello This feature could support SQL Server Analysis Services 2022 now. It's great ! Composite models on SQL Server Analysis Services | Microsoft
https://community.fabric.microsoft.com/t5/Desktop/DirectQuery-Not-Working-for-Non-Pro-License-Users/td-p/4278709
Solved: DirectQuery Not Working for Non-Pro License Users - Microsoft Fabric Community
Nov 11, 2024 - Solved: I have a DirectQurey established in a report that is published to a Power BI Workspace. One of the team members with a Demo License reported
not working
https://community.fabric.microsoft.com/t5/Desktop/Filtering-DirectQuery-table-based-on-import-mode-table-visuals/m-p/4359155
Solved: Re: Filtering DirectQuery table based on import mo... - Microsoft Fabric Community
Apr 4, 2025 - ExcludeVendorExcel = CALCULATE ( SUM ( VendorTransactionMeasure[Amount] ), KEEPFILTERS ( NOT VendorTransaction[Vendor] IN VALUES (
based on
https://community.fabric.microsoft.com/t5/Desktop/Integrated-DirectQuery-data-with-Imported-data-cannot-be/m-p/3739058
Re: Integrated DirectQuery data with Imported data... - Microsoft Fabric Community
Mar 7, 2024 - Hi Thanks for your sharing! I added some of my methods. The warning message you're seeing is Power BI's way of alerting you to potential refresh
microsoft fabricintegrateddirectquerydataimported
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/1777581
Re: Share your thoughts on DirectQuery for Power B... - Page 14 - Microsoft Fabric Community
Sep 18, 2024 - Ok, since this thread was for feedback I would say I don't find this feature useful at all unless viewers of workspaces/datasets can utilize these
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/2130096/highlight/true
Re: Share your thoughts on DirectQuery for Power B... - Page 10 - Microsoft Fabric Community
Sep 18, 2024 - I created an Idea to address this question, can you help voting? Renaming dataset measures can't break client reports (change reference from name to
https://community.fabric.microsoft.com/t5/Developer/Patching-an-Online-DirectQuery-datasource/m-p/351530
Solved: Re: Patching an Online DirectQuery datasource - Microsoft Fabric Community
Feb 4, 2018 - Hi. For cloud data sources, there is a default gateway created by Power BI. To find out the gateway and datasource ids, use this call:
microsoft fabricsolvedpatchingonlinedirectquery
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Ability-to-run-stored-procedure-using-DirectQuery/idc-p/4424395/highlight/true
Ability to run stored procedure using DirectQuery - Microsoft Fabric Community
Feb 24, 2025 - Ability to run stored procedure using direct query
stored proceduremicrosoft fabricabilityrunusing
https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2012/hh965743(v=msdn.10)?redirectedfrom=MSDN
Using DirectQuery in the Tabular BI Semantic Model | Microsoft Learn
in thesemantic modelusingdirectquerytabular
https://community.fabric.microsoft.com/t5/Desktop/DirectQuery-not-possible-to-connect-2-fact-tables-model-X-to-1/m-p/1966626/highlight/true
DirectQuery: not possible to connect 2 fact-tables... - Microsoft Fabric Community
Aug 26, 2022 - I'm using the DirectQuery-modus in Power BI Desktop to connect 2 AAS-models. These 2 models give me the necessary amount of information needed for a
not possibleto connectfact tablesmicrosoft fabricdirectquery
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Allow-Bi-Directional-filtering-for-DirectQuery-reports/idc-p/4523195
Allow Bi-Directional filtering for DirectQuery rep... - Microsoft Fabric Community
Feb 25, 2025 - The dropdown for bi-directional filtering is disabled on DirectQuery reports. This makes reporting on star schemas difficult.
microsoft fabricallowbidirectionalfiltering
https://community.fabric.microsoft.com/t5/Desktop/SQL-Server-and-PowerBI-DirectQuery-mode/td-p/2867918
SQL Server and PowerBI DirectQuery mode - Microsoft Fabric Community
Oct 28, 2022 - Hi all, I have a client masterfile table included in my data model. The table is linked in DirectQuery mode from a SQL Server. In the table query I
sql servermicrosoft fabricpowerbidirectquerymode
https://community.fabric.microsoft.com/t5/Desktop/How-to-fetch-a-Column-from-Directquery-Table/m-p/4044210
Solved: Re: How to fetch a Column from Directquery Table? - Microsoft Fabric Community
Jul 17, 2024 - , RELATED function in DAX is used to fetch a column from a related table in a one-to-many relationship. Please checkit once if it still does not work
https://community.fabric.microsoft.com/t5/Desktop/issue-with-Date-table-in-directquery/m-p/1453342/highlight/true
Re: issue with Date table in directquery - Microsoft Fabric Community
Oct 24, 2020 - I am not sure how you have applied the month filer and when you say "Not working", it is not clear enough. Please share a sample file and
with datemicrosoft fabricissuetabledirectquery
https://community.fabric.microsoft.com/t5/Desktop/Multiply-DirectQuery-row-value-with-imported-table-value-DAX/m-p/2356120/highlight/true
Solved: Re: Multiply DirectQuery row value with imported t... - Microsoft Fabric Community
Feb 23, 2022 - Thanks, that definitely helps me to understand and points me in a clearer direction. I've tried just now (with two separate measures), I am getting a
https://ammblog.azurewebsites.net/2019/03/06/schedule-directquery-cache-refresh-for-power-bi-embedded/
Schedule DirectQuery cache refresh for Power BI Embedded | Mashford's Musings
Mar 6, 2019 - Use the REST API for Power BI Embedded to set the cache refresh of a DirectQuery or live connection dataset.
power bi embeddedcache refreshscheduledirectquery
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/2735826/highlight/true
Re: Share your thoughts on DirectQuery for Power B... - Page 3 - Microsoft Fabric Community
Sep 18, 2024 - that is not supposed to happen! Can you tell me more about the relationships? Maybe look at the properties over in SSAS to see if any of them have
https://community.fabric.microsoft.com/t5/Desktop/How-to-fetch-a-Column-from-Directquery-Table/td-p/4044202
Solved: How to fetch a Column from Directquery Table? - Microsoft Fabric Community
Jul 17, 2024 - Solved: Hi Expert, I am facing an issue to fetched a column from Directquery Table(Created in Power Query 'Fields Count' ). I am using RELATED
how toa column
https://community.fabric.microsoft.com/t5/Desktop/List-of-DirectQuery-data-sources/m-p/3383274/highlight/true
Re: List of DirectQuery data sources? - Microsoft Fabric Community
Aug 16, 2023 - I filed an issue on Github. This type of documentation gap is quite frankly unacceptable.
list ofdata sourcesmicrosoft fabricdirectquerycommunity
https://community.fabric.microsoft.com/t5/Desktop/Integrated-DirectQuery-data-with-Imported-data-cannot-be/m-p/3742259
Re: Integrated DirectQuery data with Imported data... - Microsoft Fabric Community
Mar 7, 2024 - Hi! Thank you for your answer but unfortunately this does not answer my question. Here some more context: I want to show the master data in my
microsoft fabricintegrateddirectquerydataimported
https://community.fabric.microsoft.com/t5/Power-Query/PowerBI-DirectQuery-and-Salesforce/td-p/421025
Solved: PowerBI DirectQuery and Salesforce - Microsoft Fabric Community
Apr 24, 2026 - Solved: Hello all, So I have a collection of data I'd like to configure into a report with directquery mode, and publish to the web service whereas
microsoft fabricsolvedpowerbidirectquerysalesforce
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/2450495
Re: Share your thoughts on DirectQuery for Power B... - Page 7 - Microsoft Fabric Community
Sep 18, 2024 - this was launched on April 4th:
https://community.fabric.microsoft.com/t5/Desktop/List-of-DirectQuery-data-sources/m-p/3383274
Re: List of DirectQuery data sources? - Microsoft Fabric Community
Aug 16, 2023 - I filed an issue on Github. This type of documentation gap is quite frankly unacceptable.
list ofdata sourcesmicrosoft fabricdirectquerycommunity
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Documentation-on-DirectQuery-limitations-is-outdated/idc-p/4578895
Documentation on DirectQuery limitations is outdat... - Microsoft Fabric Community
Feb 25, 2025 - Documentation here is incorrect: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/ Specifically, the following
microsoft fabricdocumentationdirectquerylimitationscommunity
https://community.fabric.microsoft.com/t5/Power-Query/PowerBI-DirectQuery-and-Salesforce/m-p/421025
Solved: PowerBI DirectQuery and Salesforce - Microsoft Fabric Community
Apr 24, 2026 - Solved: Hello all, So I have a collection of data I'd like to configure into a report with directquery mode, and publish to the web service whereas
microsoft fabricsolvedpowerbidirectquerysalesforce
https://community.fabric.microsoft.com/t5/Desktop/Filtering-DirectQuery-table-based-on-import-mode-table-visuals/m-p/4359056/highlight/true
Solved: Re: Filtering DirectQuery table based on import mo... - Microsoft Fabric Community
Apr 4, 2025 - You could try ExcludeVendorExcel = CALCULATE ( COUNTROWS ( VendorTransaction ), KEEPFILTERS ( NOT VendorTransaction[Vendor] IN VALUES (
based on
https://community.fabric.microsoft.com/t5/Desktop/Field-Advanced-Properties-for-DirectQuery-Parameter-Binding/m-p/2553847
Solved: Field Advanced Properties for DirectQuery Paramete... - Microsoft Fabric Community
Jul 20, 2022 - Solved: There seems to be a bug where the Advanced Properties section for binding to a Parameter for DirectQuery randomly disappears. The report
advanced propertiesmicrosoft fabricsolvedfielddirectquery
https://community.fabric.microsoft.com/t5/Desktop/Filtering-DirectQuery-table-based-on-import-mode-table-visuals/m-p/4359056
Solved: Re: Filtering DirectQuery table based on import mo... - Microsoft Fabric Community
Apr 4, 2025 - You could try ExcludeVendorExcel = CALCULATE ( COUNTROWS ( VendorTransaction ), KEEPFILTERS ( NOT VendorTransaction[Vendor] IN VALUES (
based on
https://community.fabric.microsoft.com/t5/Desktop/Pbix-report-under-DirectQuery-mode-Questions-amp-need-help-for/m-p/1844444
Solved: Pbix report under DirectQuery mode - Questions & n... - Microsoft Fabric Community
May 17, 2021 - Solved: Hello Everybody, I have some problems in builing pbix report under DQ mode. As tables of data are hidden, I cannot creat fusions, neither add
microsoft fabricsolvedreportdirectquery
https://community.fabric.microsoft.com/t5/Service/SQL-Azure-Database-with-DirectQuery-not-automatically-refreshing/m-p/10553/highlight/true
Solved: Re: SQL Azure Database with DirectQuery not automa... - Microsoft Fabric Community
Dec 10, 2015 - This is the expected behaviour. The direct connections sends live queries and retrieve data when you interact with visuals. The reports don't refresh
sql azure
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/3149317
Re: Share your thoughts on DirectQuery for Power B... - Microsoft Fabric Community
Sep 18, 2024 - Hi dears Any GA date to give us even is not precise , please ? (Already on GA for tableau) All our data modeler are in a hurry for this great feature
share your thoughts
https://community.fabric.microsoft.com/t5/Desktop/DirectQuery-not-possible-to-connect-2-fact-tables-model-X-to-1/td-p/1966626
DirectQuery: not possible to connect 2 fact-tables... - Microsoft Fabric Community
Aug 26, 2022 - I'm using the DirectQuery-modus in Power BI Desktop to connect 2 AAS-models. These 2 models give me the necessary amount of information needed for a
not possibleto connectfact tablesmicrosoft fabricdirectquery
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/1763904
Re: Share your thoughts on DirectQuery for Power B... - Page 14 - Microsoft Fabric Community
Sep 18, 2024 - Hi, I have the same issue, although I have the newest version 2.91.884.0 64-bit (March 2021), I still can't combine two sources: excel imported data
https://community.fabric.microsoft.com/t5/Translated-Spanish-Desktop/Comparta-sus-ideas-sobre-DirectQuery-para-conjuntos-de-datos-de/m-p/1563132/highlight/true
Re: Comparta sus ideas sobre DirectQuery para conj... - Page 21 - Microsoft Fabric Community
Sep 18, 2024 - Hola Oliver, No estoy seguro de seguirte. Hablo de varios modelos, no de varias tablas dentro de un solo modelo. El modelo A tiene un esquema de
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/3097287/highlight/true
Re: Share your thoughts on DirectQuery for Power B... - Page 2 - Microsoft Fabric Community
Sep 18, 2024 - It has come to our attention that this issue has been solved! I have not found any official Microsoft communication regarding this, but we discovered
https://community.fabric.microsoft.com/t5/Desktop/Integrated-DirectQuery-data-with-Imported-data-cannot-be/m-p/3742259/highlight/true
Re: Integrated DirectQuery data with Imported data... - Microsoft Fabric Community
Mar 7, 2024 - Hi! Thank you for your answer but unfortunately this does not answer my question. Here some more context: I want to show the master data in my
microsoft fabricintegrateddirectquerydataimported
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/2664723
Re: Share your thoughts on DirectQuery for Power B... - Page 6 - Microsoft Fabric Community
Sep 18, 2024 - Sorry for the delay in getting back to you. Yes, this is still a problem. I created an example for you. SourceModel.bim which is used as the source
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/2648334/highlight/true
Re: Share your thoughts on DirectQuery for Power B... - Page 5 - Microsoft Fabric Community
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/1777551
Re: Share your thoughts on DirectQuery for Power B... - Page 14 - Microsoft Fabric Community
Sep 18, 2024 - Will do. We've played with it a lot, the functionality works except for viewers essentially.
https://community.fabric.microsoft.com/t5/Desktop/Filtering-DirectQuery-table-based-on-import-mode-table-visuals/m-p/4358013/highlight/true
Solved: Re: Filtering DirectQuery table based on import mo... - Microsoft Fabric Community
Apr 4, 2025 - Hi, Please share some sample data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
based on
https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/2135820
Re: Share your thoughts on DirectQuery for Power B... - Page 9 - Microsoft Fabric Community
Sep 18, 2024 - When the composite dataset is refreshing, the visuals will not load until the refresh is over. This can take easily over 10 mins depending on the