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

Your Oracle data import in Power BI and Power Query is slow?

If you’re using the native Oracle connector in Power Query, you will probably experience a very slow import performance. Thanks to Tristan Malherbe for recommending to use the OleDB-connector in (…) Read more

  • 2021-01-12
  • Comments 7
  • Filed under: M, 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 2
  • 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 15
  • Filed under: Excel, Function, M, Power BI, Power Query

Convert DateTime to ISO 8601 date and time strings in Power Query

Often, when querying APIs it is required to enter date and time filters in ISO 8601 format . Today I show a quick way to convert DateTime to ISO 8601 string, (…) Read more

  • 2020-10-11
  • Comment 1
  • Filed under: Dataflows, Function, little Tipps&Tricks, M, Power BI, Power Query

Retrieve header fields like response status from Web.Contents in Power BI and Power Query

Many Power Query function not only return their values as advertised in their function documentation, but on top of that a metadata record. This record is like tag that holds (…) Read more

  • 2020-09-19
  • Comments 0
  • Filed under: Function, M, Power BI, Power Query

Split up an existing Power BI report into a Golden Dataset and a thin report

The other day I discovered a neat way to split up an existing Power BI report into a Golden Dataset and a thin report file with very few adjustments to (…) Read more

  • 2020-09-17
  • Comments 2
  • Filed under: Allgemein
← 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
  • © 2021 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

Search by tag

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

Follow me on Twitter

My Tweets