BI Insight
DECEMBER 16, 2020
It has been a long time that I use SQL Server Profiler to diagnose my data models in the Power BI Desktop. I wrote a blog post in June 2016 about connecting to the underlying Power BI Desktop model from different tools, including SQL Server Management Studio (SSMS), Excel and SQL Server Profiler.
BI Insight
DECEMBER 16, 2020
It has been a long time that I use SQL Server Profiler to diagnose my data models in the Power BI Desktop. I wrote a blog post in June 2016 about connecting to the underlying Power BI Desktop model from different tools, including SQL Server Management Studio (SSMS), Excel and SQL Server Profiler.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Sisense
APRIL 24, 2019
For example, let’s assume 200 sales have been made in the year 2016, and we want to query for the number of sales per customer in 2016. HAVING Sales.LastSaleDate BETWEEN #1/1/2016# AND #12/31/2016#. WHERE Sales.LastSaleDate BETWEEN #1/1/2016# AND #12/31/2016#. FROM Customers. INNER JOIN Sales.
ElegantJ BI
JANUARY 3, 2019
These business users have adopted business intelligence and advanced analytical tools to gather and analyze data from varied data sources and use that analysis to identify the root cause of problems, identify opportunities, solve problems and share crucial data to support business decisions.
ElegantJ BI
JANUARY 3, 2019
These business users have adopted business intelligence and advanced analytical tools to gather and analyze data from varied data sources and use that analysis to identify the root cause of problems, identify opportunities, solve problems and share crucial data to support business decisions.
ElegantJ BI
JANUARY 3, 2019
These business users have adopted business intelligence and advanced analytical tools to gather and analyze data from varied data sources and use that analysis to identify the root cause of problems, identify opportunities, solve problems and share crucial data to support business decisions.
BI Insight
JULY 13, 2017
Update 2021 March: You can now export the data directly from Power BI Desktop using our free external tool, Power BI Exporter. Update 2019 April: If you want to export the data model from either Power BI Desktop or Power BI Service to CSV or SQL Server check this out. Read more here.
Expert insights. Personalized for you.
258 
Let's personalize your content