Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be shared with others, as required. Data may be connected from different sources including files, databases, Azure services, […]
2021-07-12
7,028 reads
Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]
2021-01-12
1,588 reads
A critique of a first attempt to write an M query to convert a folder full of images to text that caused PowerQuery to perform multiple file reads
2019-05-31
This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports.
2019-05-31
Dave Mason takes us through his journey in learning how to visualize data with R, in Power BI desktop.
2019-05-31
2019-05-23
Now that you know about the dimension and fact tab...
2019-05-22
2019-05-22
Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html https://blog.gbrueckl.at/base64/ Since they wrote those posts, however,...
2019-05-20
One of the many big announcements at Build this week, and one that caused a lot of discussion on Twitter, was about Wrangling Data Flows in Azure Data Factory....
2019-05-10
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...
By Rayis Imayev
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...
Hello friends, This issue is a little hard to explain, but I hope you...
I have created a webpage with a form that allows people to register for...
I'm currently interested in self-hosting and I recognized that mostly it's about alternatives for...
Ask SSC