Power BI can get data from Google Sheet now. This functionality is released just yesterday and announced in both Power BI and Power Query blogs. The feature is still preview (Beta) but it is worthwhile looking at how it works in a quick article and video. Video Google Sheet’s URL To get data from a Read more about Power BI Get Data from Google Sheets[…]
Get data from a Power BI dataset is creating a live connection, which is the recommended way, because you will get the entire model. However, sometimes you want to import the data from the model so that you can add other things to it (like another data source). The ability to have a composite model Read more about How to IMPORT data from a Power BI dataset – Premium-only[…]
The ability to use Get Data from Folder in Power BI is a very useful option. However, if your sheet names are different in the list of Excel files, then you will face a problem. In this blog article, I’ll explain a method you can use that works regardless of the sheet names. Sample Dataset Read more about Get Data from Multiple Excel Files with Different Sheet Names into Power BI[…]
There are times that you need to get the list of FOLDERS and not just files. Of course folder itself (without considering files in it), doesn’t contain data to be used for a report. However, sometimes, even the folder name might contain some useful information. The Get Data From Folder option in Power BI will Read more about Get the List of FOLDERS only in Power BI using Power Query[…]