The BIccountant

New Generation Finance – Accounting – Controlling using Microsoft BI stack

  • Home
  • Learning resources
  • Speed/Performance aspects
  • About The BIccountant
  • Imprint
  • Datenschutz/Privacy

Archives

  • Menu
  • Sidebar

Posts in Category ‘Excel’

Workaround to connect to Power BI dataflows from Power Query in Excel

Currently, we cannot connect to Power BI dataflows from Excel Power Query. And as we also cannot use custom connectors in there, we need a different alternative. I’m going to (…) Read more

  • 2021-01-24
  • Comments 8
  • Filed under: Dataflows, Excel, Function, Power BI, Power Query

How to refresh Power Queries on protected sheets in Excel

When working with Power Query in Excel you might want to refresh Power Queries on protected sheets. But this will not work by default. Using a macro to temporarily unprotect (…) Read more

  • 2020-11-18
  • Comments 4
  • Filed under: Excel, Power Query

Improve File Import from SharePoint in Power BI and Power Query

When you use the UI to import files from SharePoint, you’ll end up with the Sharepoint.Files function. This function can become fairly or super slow when you use it on (…) Read more

  • 2020-11-16
  • Comments 63
  • Filed under: Excel, Function, M, Power BI, Power Query

Tips to download files from webpages in Power Query and Power BI

When downloading data from the web, it’s often best to grab the data from APIs that are designed for machine-to-machine communication than from the site that’s actually visible on the (…) Read more

  • 2020-04-06
  • Comments 3
  • Filed under: Excel, little Tipps&Tricks, M, Power BI, Power Query

Advanced transformations on multiple columns at once in Power BI and Power Query

You can apply simple transformations to multiple columns at once in Power Query using the UI only. In this article I show how you can apply advanced transformations on multiple (…) Read more

  • 2019-12-18
  • Comments 9
  • Filed under: Excel, Function, M, Power BI, Power Query

Export large amount of data from Power BI desktop visuals

I’m going to show how to export data from visuals in Power BI Desktop that’s too big to be downloaded by the native functionality and therefore returns this error-message: Check (…) Read more

  • 2019-07-28
  • Comments 11
  • Filed under: DAX, Excel, Power BI
← Older entries
Newer entries →
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy / Datenschutzerklärung
  • © 2023 The BIccountant
  • Powered by WordPress
  • Theme: Tatami by Elmastudio
Top

The BIccountant

New Generation Finance,  Accounting & Controlling using Microsoft BI stack

Business inquiries

info@thebiccountant.com

Follow me!

  • Twitter
  • YouTube
  • GitHub
  • LinkedIn
  • RSS Feed

Log In

Categories

  • Accounting (24)
  • Allgemein (17)
  • Bug warning (3)
  • Charting (8)
  • Cube (7)
  • Data Modelling (11)
  • Dataflow (3)
  • Dataflows (5)
  • DAX (23)
  • Excel (89)
  • Finance (6)
  • Flow (6)
  • Function (22)
  • little Tipps&Tricks (41)
  • M (117)
  • nerdy (9)
  • Power Automate (3)
  • Power BI (154)
  • Power Pivot (29)
  • Power Query (157)
  • Python (1)
  • R (9)
  • SSAS (6)
  • Tools (7)

Search by tag

Accounting Charting Cube DAX Excel Finance Flow Function JSON M Performance PowerBI Power BI Power Pivot Power Query PowerQuery R SSAS Text transformation Tools